Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup backwards
vlookup looks for the lookup value in the left most column of the table
array. Is it possible for it to look for the value in the right most column of the table and return a value from a column to the left? This is backwards from the vlookup statement - I realize. I can't tranpose the columns in the table array because they needed to stay formatted in this particular way. |
#2
|
|||
|
|||
Look for examples with INDEX combined with MATCH.
jtoy wrote: vlookup looks for the lookup value in the left most column of the table array. Is it possible for it to look for the value in the right most column of the table and return a value from a column to the left? This is backwards from the vlookup statement - I realize. I can't tranpose the columns in the table array because they needed to stay formatted in this particular way. |
#3
|
|||
|
|||
See the section on "Left Lookups" at
http://www.cpearson.com/excel/lookups.htm . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jtoy" wrote in message ... vlookup looks for the lookup value in the left most column of the table array. Is it possible for it to look for the value in the right most column of the table and return a value from a column to the left? This is backwards from the vlookup statement - I realize. I can't tranpose the columns in the table array because they needed to stay formatted in this particular way. |
#4
|
|||
|
|||
Thanks for the link Chip - this was the first option I tried and the
suggestion seemed very easy to follow, but for some reason I couldn't get it to work. It suggested using the OFFSET and MATCH functions. I did however get it to finally work with the INDEX and MATCH function. "Chip Pearson" wrote: See the section on "Left Lookups" at http://www.cpearson.com/excel/lookups.htm . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jtoy" wrote in message ... vlookup looks for the lookup value in the left most column of the table array. Is it possible for it to look for the value in the right most column of the table and return a value from a column to the left? This is backwards from the vlookup statement - I realize. I can't tranpose the columns in the table array because they needed to stay formatted in this particular way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |