something like VLOOKUP

Colin Legg · #1 03-13-2012, 02:23 AM

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).

hanvyj · #2 03-13-2012, 02:38 AM

Quote:

Originally Posted by Colin Legg

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!

Catalin.B · #3 03-13-2012, 08:47 AM

Off topic: Congratulations Colin, just noticed you are a Super Moderator now... I was wondering how is Paul dealing alone with all the work

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup & IF together	thelauncher	Excel	5	08-25-2013 11:32 PM
Vlookup	ibrahimaa	Excel	5	03-04-2012 11:24 AM
Vlookup	ibrahimaa	Excel	8	01-03-2012 09:32 PM
Vlookup	Karen615	Excel	4	09-12-2011 02:30 PM
Help with VLOOKUP	sakhtar	Excel	2	07-24-2010 07:39 PM