look up formula not working

[Mattrixdesign]

I am using the formula

=LOOKUP(F3,B3:B26,C3:C26)

Where column B is a Name of a Currency and column C the exchange rate. F3 is the choice of currency.

HOEVER the result seems odd, when I select a currency I either get the WRONG RATE for the currency, or #na or the right figure - whats is going on, what am I doing wrong?

 

[IML]

On 2002-10-09 10:42, Mattrixdesign wrote:
I am using the formula

=LOOKUP(F3,B3:B26,C3:C26)

Where column B is a Name of a Currency and column C the exchange rate. F3 is the choice of currency.

HOEVER the result seems odd, when I select a currency I either get the WRONG RATE for the currency, or #na or the right figure - whats is going on, what am I doing wrong?

does
=vlookup(f3,$b$3:$c$26,2,0)

work for you?
I don't know the nuances of lookup, but this vlookup as structured will look for an exact match and return the associated rate. If not fund, n/a will be returned.

Good luck

 

[Mattrixdesign]

GENIUS - good man, I thank U, CHEERS