| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VLookup ... Left side?
Excel 2000 ... I know how to use VLOOKUP function ...
However, the data I need to capture is in a Range to the LEFT of the data I need to target ... VLOOKUP works if data Range is to the RIGHT of the target. ie: I want to target a value in Col N ... & then capture the value (alpha-numeric) in Col J. How do I do this? ... Thanks ... Kha |
|
#2
|
|||
|
|||
|
=INDEX(J:J,MATCH(LookupValue,N:N,0))
Substitute the actual ranges for the whole columns if it's convenient/needed to do so. Ken wrote: Excel 2000 ... I know how to use VLOOKUP function ... However, the data I need to capture is in a Range to the LEFT of the data I need to target ... VLOOKUP works if data Range is to the RIGHT of the target. ie: I want to target a value in Col N ... & then capture the value (alpha-numeric) in Col J. How do I do this? ... Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open two excel windows side by side | Excel Discussion (Misc queries) | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
| In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
Linear Mode
