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

"amy" wrote in message
...
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