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