simple if then function

[Guest]

I know this should be simple but I am having problems
if f9=xa then f20=133
if f9=tc then f20=168
if f9=xb then f20= 145

I had done these years ago and just can't get this simple formula to work.
Any help you can give me would be greatly appreciated.

Thank you

 

[N Harkawat]

=hlookup(F9,{"xa","tc","xb";133,168,145},2,0)

 

[dominicb]

Good afternoon Amy

This formula when placed in cell F20 will do what you want. If F9
doesn't equal xa, tx or xb then the cell will show as empty.

=IF(F9="xa",133,IF(F9="tc",168,IF(F9="xb",155,"")))

HTH

DominicB

 

[Guest]

tHANK YOU FOR YOUR EHLP IT WORKED GREAT. nEVER USED HLOOKUP BEFORE

 

[CLR]

IN cell F20 put this formula....

=IF(F9="xa",133,IF(F9="tc",168,IF(F9="XB",145,"")))

Vaya con Dios,
Chuck, CABGx3