VLOOKUP problem

M

Mortir

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

BoniM

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

Niek Otten

Use

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

See HELP for details

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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