LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default Lookup, looking up one row above the actual row

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP ( ) Epinn Excel Worksheet Functions 10 October 18th 06 02:10 AM
How do I get correct results when LOOKUP with calculated numbers onthemountain Excel Worksheet Functions 2 July 20th 06 01:13 AM
Lookup function gives wrong values occasionally [email protected] Excel Discussion (Misc queries) 3 July 1st 06 12:58 AM
Lookup function help marlea Excel Worksheet Functions 4 August 30th 05 08:11 PM
Lookup Function help marlea Excel Discussion (Misc queries) 2 August 23rd 05 07:30 PM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"