VLOOKUP *Left* Value
Where your regular VLOOKUP table is in H1:I5, and your new list to the left
is in G1:G5, then put this in B1 to lookup any value in A1
=INDEX(G:G,MATCH(VLOOKUP(A1,H:H,1,FALSE),H:I,0))
Vaya con Dios,
Chuck, CABGx3
"jim" wrote:
Is there a way to lookup a value in a column and return the
corresponding value in the *left* column? I'm familiar with VLOOKUP,
but didn't know if there's an alternative to re-ordering all of my
data.
Thanks for any insight.
|