VLOOKUP LEFT VS RIGHT

J

Jerry

Can I compose a VLOOKUP formula that looks left instead of right. I have
data in C10 and want to go left 4 cells and get that data. Can this be
done. I don't think so but I'm no expert in VLOOKUP.
 
T

T. Valko

VLOOKUP works from left to right.
I have data in C10 and want to go left 4 cells and get that data
Click to expand...

4 cells left of C10? There aren't 4 columns to the left of column C.

You can use something like this:

=INDEX(range,MATCH(lookup_value,lookup_array,0))
 
Top