Vlookup - Way to get around searching on 1st column?

  • Thread starter Thread starter bimmerman
  • Start date Start date
B

bimmerman

Is there a way to get around this?

I want to search on row F but return the value from row A.

I don't even want to show the data in row F so that's why I don't wan
to put it in front of A and have an empty looking column.

Thanks for any help
 
Is there a way to get around this?

I want to search on row F but return the value from row A.

I don't even want to show the data in row F so that's why I don't want
to put it in front of A and have an empty looking column.
Click to expand...

Standard approach is INDEX(..,MATCH(..)), e.g.,

=INDEX(A1:A100,MATCH(SomeValue,F1:F100,0))
 
Here's something I've worked up, maybe it'll work for u.

+OFFSET(C11,MATCH(B2,$C$11:$C$22,0)-1,-1)

with the lookup value in B2, and c11:c22 containing a list that may include
that value. What this does is lookup value b2 in c11:c22, then gives you
what's contained one column to the left (b11:b22). Change it to suit you
since you want to go from F to A.
 
Forgot to point out, what would be changed is the final "-1" depending on
how many columns you want to go to the left.
 
Thanks, I'll try that 2nd one out later as I get some time, for the tim
being, I just created a new row A and put my values in there and hi
the whole column.

Thanks
 
You're welcome, though after I saw Harlan's 'standard' approach, it looks
easier to digest and probably easier for you to implement.

The way he wrote it, the INDEX part will return a return a value from
A1:A100 where the lookup value is written within the MATCH part, and the
range to lookup the value in is F1:F100.
 
Back
Top