VLOOKUP *Left* Value
I'll give these a try. Thanks folks.
Jim
Andy wrote:
Hi
Have a look at using INDEX and MATCH together. I would suggest either Excel
Help or this newsgroup. Something like this format:
=INDEX(D12:D20,MATCH("f",E12:E20,0))
Andy.
"jim" wrote in message
ups.com...
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.
|