_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 of 299 in H3 i wish to compare to L1:P1. The correct
column is M.
With that established, I now want to compare a value of 19490 in I3 to
the numbers in column M. I wish to return the row number. In this case,
row 3.
How can I accomplish this? I have tried several suggestions. None have
worked.


--
spxer
------------------------------------------------------------------------
spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025
View this thread: http://www.excelforum.com/showthread...hreadid=569606