Vlookup to the left?

[Mac]

=Vlookup(a1,Range,6,FALSE)

Vlookup will count 6 column to the right and grab the value. Can I use
Vlookup to count to the left something like -6?

Thanks,
mac

 

[Lars-Åke Aspelin]

=Vlookup(a1,Range,6,FALSE)

Vlookup will count 6 column to the right and grab the value. Can I use
Vlookup to count to the left something like -6?

Thanks,
mac

You can not use a negative value for the col_index_num parameter in
VLOOKUP.

Try this formula instead:

=LOOKUP(A1,myrange,OFFSET(myrange,0,-6))

Hope this helps / Lars-Åke

 

[Ted M H]

VLOOKUP only goes to the right. But you can easily go left by using a
combination of MATCH and INDEX.
Data:
Lookup Table Lookup formula
Amount Name FindName FindAmount
500 Joe Steve
85 Steve Cindy
200 Darla
300 Cindy
You need to lookup up the names in the FindName column in the Lookup Table's
Name column and return to the FindAmount column the Amount in the Lookup
Table.
Put this formula into the FindAmount cells next to Steve and Cindy:
=INDEX(Amount,MATCH(C3,Name,0))
Amount and Name are named ranges for the cells with data in columns A and B.
FindName is column C (C3=Steve, C4=Cindy).
0 as MATCH argument is like using FALSE in VLOOKUP (Exact match).
Formula goes in column D (FindAmount)

 

[Mac]

Thanks All,

I'll give it a try....

 

[MGuevara]

Have you actually tried this -
I just tried and get a #N/A ...so I'm not sure if I'm doing something wrong
or if vlookup only looks right.