| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup value from previous column
The instructions for vlookup say the lookup value must be in the first column
of the lookup array. Unfortunately I want to look up values in a spreadsheet with a standard format which I can't change, and the lookup value is in column B and the value I want to return is in column A. Is there a clever trick of getting vlookup to do this (other than simply making a personal copy of the spreadsheet with the columns reversed)? Grateful for ideas. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup value from previous column
=INDEX(A:A,MATCH(D2,B:B,0))
Matches the exact value in D2 with a value in column B and returns column A. Adjust as desired. "simonc" wrote: The instructions for vlookup say the lookup value must be in the first column of the lookup array. Unfortunately I want to look up values in a spreadsheet with a standard format which I can't change, and the lookup value is in column B and the value I want to return is in column A. Is there a clever trick of getting vlookup to do this (other than simply making a personal copy of the spreadsheet with the columns reversed)? Grateful for ideas. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up previous data in column within an IF statement | Excel Worksheet Functions | |||
| find a value in a table, go to the previous column and add that co | Excel Worksheet Functions | |||
| vlookup reverts to data from a previous report | Excel Worksheet Functions | |||
| Referencing previous column in COUNTIF | Excel Discussion (Misc queries) | |||
| Data in column predetermined by what has been entered in previous | Excel Discussion (Misc queries) | |||
Linear Mode
