Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup alteration
The vlookup function is traditionally used to search for a value in the
leftmost column of a table, and then returns a value in the same row from a column you specify in the table. However is it possible to tell vlookup to ignore the first value in a column and use the second version and then return the value in the same row in the next column. I am interesting in using this as I have multiple versions of the same value in a column Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |