MrExcel Publishing
Your One Stop for Excel Tips & Solutions

LOOKUP not working?


Posted by carter on November 01, 2001 11:11 AM

I want to do a very simple lookup. It looks like this:

=LOOKUP(H16,Products!B:B,Products!C:C)

But for some reason the lookup skips over the right row and puts in the value from the table last row.

What's going on?


Posted by carter on November 01, 2001 11:15 AM

Must I sort the table by the lookup column?


Posted by Jason Davis on November 01, 2001 11:18 AM

If LOOKUP can't find the lookup_value, it matches the largest value in lookup_vector that is less than or equal to lookup_value.

if thats not your problem then you might trying defining your range ie.. b1:b30000

Posted by Todd on November 01, 2001 11:19 AM

Don't use the lookup function. Use Vlookup, Hlookup, or Index.


Posted by Mark W. on November 01, 2001 11:24 AM

Todd's right... LOOKUP was included in Excel to be backward compatible earlier spreadsheets