Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP problem | Excel Discussion (Misc queries) | |||
vlookup problem | Excel Discussion (Misc queries) | |||
VLookUp problem | Excel Worksheet Functions | |||
Vlookup problem | Excel Worksheet Functions | |||
Vlookup Problem | Excel Worksheet Functions |