Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel Lookup Problem.
Lets say I have a spreatsheet like this: 12_11 123 34_15 457 56_18 80 90_21 67 When I am using Vlookup("90_21", range, 2) I get an answer 80. Ofcourse, my actual spreadhseet is much bigger and different than the above. Any help why the lookup is looking at one row above the actual row it should be looking up. Please let me know if there is a way I can upload the spreadsheet so that I can let the Gurus troubleshoot more effectively. Thanks Mario |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LOOKUP ( ) | Excel Worksheet Functions | |||
How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
Lookup function gives wrong values occasionally | Excel Discussion (Misc queries) | |||
Lookup function help | Excel Worksheet Functions | |||
Lookup Function help | Excel Discussion (Misc queries) |