Microsoft Office Forums - View Single Post - something like VLOOKUP

Thread: something like VLOOKUP

View Single Post

Old

03-13-2012, 02:38 AM

hanvyj

hanvyj is offline

hanvyj uses Windows XP

Windows XP hanvyj uses Office 2003

hanvyj uses Office 2003

Office 2003

Advanced Beginner

The original poster

Join Date: Feb 2012

Posts: 33

hanvyj is on a distinguished road

Default

Quote:

Originally Posted by Colin Legg

View Post

Hi,

=INDEX(A1:A10,MATCH(D1,B1:B10)+(LOOKUP(D1,B1:B10)< D1))

where A1:B10 contains the table you posted and D1 contains the value to look up (eg 340).

Thank you, that works really well!

Reply With Quote