Any Way to Use Vlookup in Reverse?
 

Is there any formula in Excel that works like "vlookup", but reads right to
left?

I know there are workarounds for this (namely, repeating columns), but I
encounter this more than I'd think and it would be nice to have a better
solution. Using Excel 2003.

Thanks!

Chris

Any Way to Use Vlookup in Reverse?
 

Here's the general idea:

...........A..........B
1.......Joe........a
2.......Sue.......b
3......Tom......c
4......Liz........d

Lookup the name associated with b.

D1 = lookup value = b

=INDEX(A1:A4,MATCH(D1,B1:B4,0))

--
Biff
Microsoft Excel MVP


"opieandy" wrote in message
...
Is there any formula in Excel that works like "vlookup", but reads right
to
left?

I know there are workarounds for this (namely, repeating columns), but I
encounter this more than I'd think and it would be nice to have a better
solution. Using Excel 2003.

Thanks!

Chris

Any Way to Use Vlookup in Reverse?
 

Thanks, Biff!!!

"T. Valko" wrote:

Here's the general idea:

...........A..........B
1.......Joe........a
2.......Sue.......b
3......Tom......c
4......Liz........d

Lookup the name associated with b.

D1 = lookup value = b

=INDEX(A1:A4,MATCH(D1,B1:B4,0))

--
Biff
Microsoft Excel MVP


"opieandy" wrote in message
...
Is there any formula in Excel that works like "vlookup", but reads right
to
left?

I know there are workarounds for this (namely, repeating columns), but I
encounter this more than I'd think and it would be nice to have a better
solution. Using Excel 2003.

Thanks!

Chris

Any Way to Use Vlookup in Reverse?
 

You're welcome!

--
Biff
Microsoft Excel MVP


"opieandy" wrote in message
...
Thanks, Biff!!!

"T. Valko" wrote:

Here's the general idea:

...........A..........B
1.......Joe........a
2.......Sue.......b
3......Tom......c
4......Liz........d

Lookup the name associated with b.

D1 = lookup value = b

=INDEX(A1:A4,MATCH(D1,B1:B4,0))

--
Biff
Microsoft Excel MVP


"opieandy" wrote in message
...
Is there any formula in Excel that works like "vlookup", but reads
right
to
left?

I know there are workarounds for this (namely, repeating columns), but
I
encounter this more than I'd think and it would be nice to have a
better
solution. Using Excel 2003.

Thanks!

Chris