A b c d
100 100 x
100 y
100 z
i want to lookup 100 in colum b with a result of z instead of x in criteria c:d
A b c d
100 100 x
100 y
100 z
i want to lookup 100 in colum b with a result of z instead of x in criteria c:d
Try using the Lookup formula
=LOOKUP(100,A1:A3,B1:B3)
Look at this link
http://support.microsoft.com/kb/214069
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Assuming the lookup value is in cell G2 and the values are sorted, then you could use:
Formula:Please Login or Register to view this content.
See the example
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks