Use INDEX/MATCH instead:
=INDEX(D1:D100,MATCH(A1,E1:100))

will search for A1 in E1:E100 and return corresonding value in column D

HTH
--
AP

"jim" a écrit dans le message de news:
...
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.