I have copied my formula below, please let me know if I am understanding
you correctly:

=VLOOKUP(F7,J19:L29,3,FALSE)

by changing the 3rd part of the equation, I am changing the LOOKUP /
Index Number. If I were to change that to a "-1", it would not
reference the data.

I'm sure I am missunderstanding you, and I do not have much experience
with the "MATCH" function.


--
wmaughan
------------------------------------------------------------------------
wmaughan's Profile: http://www.excelforum.com/member.php...o&userid=29743
View this thread: http://www.excelforum.com/showthread...hreadid=494600