VLOOUP

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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!
=====================================================

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
 
Back
Top