You might want to explain yourself better. If so, anyone can help you. Are
you talking about looking up a lookup-value in the fifth column of a lookup
range, or looking up a lookup-value offset by 4 columns, in the lookup
range?

Tyro

"RoadKill" wrote in message
...
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