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