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

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

I had a typo. What I want is to replace A4 with E4 in this:
vlookup(A4,Sheet1!A1:T100,16,0).

Yes, it is true what you say. But I want it to pull the 16th column of
Sheet1. That does not change.

Sheet2 has data in A4:D100. So unfortunately the data that I want to match
Sheet2 to Sheet1 is in E4 of Sheet2.

Thank you


"Tyro" wrote:

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