Microsoft Office Forums - View Single Post - something like VLOOKUP

Thread: something like VLOOKUP

View Single Post

Old

03-13-2012, 02:23 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

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

Reply With Quote