K L M N O P .............
1 100 200 300 400 500
2 1900 1900 1900 1900 1900
3 19240 19480 19720 19960 20200
4 19600 20200 20800 21400 22000
L1:AE1 is the table index headers
L2:AE1000 is the values to compare to
K will compare a value from H to L1:AE1 to determine the column and
then K will compare a value from I to the appropriate column to find
the nearest number and return its row(2,3,4etc.)
I looked at Index(array,Match(),Match()), but Index looks for row first
and I need to establish column first.
--
spxer
------------------------------------------------------------------------
spxer's Profile:
http://www.excelforum.com/member.php...o&userid=37025
View this thread:
http://www.excelforum.com/showthread...hreadid=568648