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.
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.
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" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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.
>
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >
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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks