Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP using Fifth Column
Is there an easy way to accomplish this?
It's much easier to do this via index/match, eg use: =INDEX(Sheet1!P:P,MATCH(E4,Sheet1!E:E,0)) where you can easily frame it up to match on any col, and return any other col to the right or left of the match col. In the example, the match is done on the 5th col (col E) in Sheet1, and the front INDEX part, viz: INDEX(Sheet1!P:P, ... is the desired return col (col P) in Sheet1 where the match occurs. Adapt to suit. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "RoadKill" wrote: Hello, My understanding is that the VLOOKUP function only works when using the first column in a data range to look something up, such as vlookup(A4, Sheet1!A1:T100,16,0). Well what I would like to do is use the fifth column in the range. So I would replace A1 to use this: vlookup(E4, Sheet1!A1:T100,16,0). Is there an easy way to accomplish this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup 1st column time 2nd column text | Excel Worksheet Functions | |||
VLOOKUP using Fifth Column | Excel Worksheet Functions | |||
vlookup a value in column B but return value in Column A | Excel Discussion (Misc queries) | |||
VLookup & Column Sum | Excel Worksheet Functions | |||
Vlookup a column then a row | Excel Worksheet Functions |