I have over 1000 cells to compare to over 50 values. lets say A1:A50 is
values of 100 through 10,045, but not evenly divided (can't make this
easy or anyone could do it, even me.) b1:b50 is 1 through 50. Now I
have a coulmn of 1000 numbers to associate with the table a,b. Find the
number in column "a" that is less than the number in question but the
next number down is greater. then return the coresponding number in
column b. IE; say the number to compare is 222. in table a,b we find a
number series .....a5=201, a6=220, a7=235..... a5 or 220 is the correct
asociation. and b6 is returned.
Miguel, What is your reference to $ called? I could not find this in
help.
Thanks again and all for any help.


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