VLOOKUP using Fifth Column
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
|