Use

VLOOKUP(A10;A1:B7;2;FALSE)

See HELP for details

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mortir" wrote in message oups.com...
|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...
|