Thread: VLOOKUP problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mortir Mortir is offline
external usenet poster
 
Posts: 34
Default 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...