Is there a way to do a reverse VLOOKUP with negative numbers?

[cjcobra]

I doubt there is, but thought I would throw the question out there. There are times when my main lookup value is on the right side of my data set. It would be great to do a VLOOKUP with a "-5" as my column, and it would grab from right to left of the data set.

 

[njimack]

Take a look at INDEX and MATCH. Once you've mastered them, you'll never go back to using VLOOKUP.