=VLOOKUP(A10,A1:B7,2,0)
You need the fourth parameter set to false (0) or else you need the first
column of your data sorted ascending. The above formula will work without
rearranging your table.

"Mortir" wrote:

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...