| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vllokup
I am trying to use a Vlookup formula but the reference value is not in the
first colum of the range but in the third. Is there a way to get around it. Thanks in advance. RK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vllokup
Not with VLOOKUP but perhaps INDEX/MATCH. Can you give an example of your
data? "rk0909" wrote: I am trying to use a Vlookup formula but the reference value is not in the first colum of the range but in the third. Is there a way to get around it. Thanks in advance. RK |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vllokup
actually it did work using index/match combination. Thanks.
"Toppers" wrote: Not with VLOOKUP but perhaps INDEX/MATCH. Can you give an example of your data? "rk0909" wrote: I am trying to use a Vlookup formula but the reference value is not in the first colum of the range but in the third. Is there a way to get around it. Thanks in advance. RK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLLOKUP formulas | Excel Discussion (Misc queries) | |||
| VLLOKUP - more than one result?? | Excel Worksheet Functions | |||
| Find last match in vllokup | Excel Discussion (Misc queries) | |||
| Using VLLOKUP | Excel Worksheet Functions | |||
Linear Mode
