Jeff Spiccoli Wrote:
Hey, what if the numbers aren't an exact match. How do I have it choose
the
number above, below, closest, etc?

To find the closest match, you would have to change the "Match Type"
(3rd argument) in your MATCH function from 0 to either 1 for the
largest value that's less than or equal to the lookup value (the lookup
array must be arranged in ascending order) or -1 for the smallest value
that's greater than or equal to the lookup value (the lookup array must
be arranged in descending order).


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=275005