It all depends on how you use it, if for instance K2 tells which column to
look in then use it like

=INDEX(Table,Match(),K2)

Otherwise you need to come up with a better explanation with a concrete
example


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"spxer" wrote in
message ...

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