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