Does anyone know if it is possible to do a vlook where the column_index is a
negative or works from the right a goes to the left. My data base has the
lookup value to the right of the target data.

=VLOOKUP(A2,SHEET2!H:J,-3,FALSE) = Error

Thanks

The Index and Match combination can work that way.

=INDEX(Sheet2!H:H,MATCH(A2,Sheet2!J:J,0))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Matt" wrote in message
...
Does anyone know if it is possible to do a vlook where the column_index is a
negative or works from the right a goes to the left. My data base has the
lookup value to the right of the target data.

=VLOOKUP(A2,SHEET2!H:J,-3,FALSE) = Error

Thanks

You can't use Vlookup to return data to the left of the lookup column. You
need to use a combination of Index and Match to accomplish this, as in:

=index(Sheet2!A:J,match(a2,sheet2!H:H,false),4)

Regards,
Fred

"Matt" wrote in message
...
Does anyone know if it is possible to do a vlook where the column_index is
a
negative or works from the right a goes to the left. My data base has the
lookup value to the right of the target data.

=VLOOKUP(A2,SHEET2!H:J,-3,FALSE) = Error

Thanks