This will return 3
=MATCH($I$3,INDEX($L$1:$P$4,,MATCH($H$3,$L$1:$P$1, 1)),1)
if you want to return what's in the cell you need to build a bit more
=INDEX($L$1:$P$4,MATCH($I$3,INDEX($L$1:$P$4,,MATCH ($H$3,$L$1:$P$1,1)),1),MATCH($H$3,$L$1:$P$1,1))
you can shorten it using offset however then the formula will be volatile
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"spxer" wrote in
message ...
__K____L____ _M ____N ____O ____P .............
1____100___200_ _300 __400 __500
2____19000_19000_19000_19000_19000
3____19240_19480_19720_19960_20200
4____19600_20200_20800_21400_22000
I have a value in H3 of 251. I have a value in I3 of 19492.
The correct column to find is M. The correct row is 3. The result I
wish to return is 3. Suggestions?
--
spxer
------------------------------------------------------------------------
spxer's Profile:
http://www.excelforum.com/member.php...o&userid=37025
View this thread: http://www.excelforum.com/showthread...hreadid=568648