This may be better
__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