VLOOKUP problem
I have the following problem
A B
AUD 1
CAD 2
HRK 3
CZK 4
HUF 5
CHF 6
USD 7
Now i have a cell, lets say A10 in which I would write one of the
values (eg. HRK) from column one, and a cell with formula
=VLOOKUP(A10;A1:B7;2), which should then lookup the coresponding
number next to HRK - and should return nr. 3. The problem that I get
is that it doesnt return the right number... and i have no clue to
whats wrong...
|