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

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

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