mrice- thanks for the suggestion, but my values in column 3 aren't and
can't be put in ascending order (they are results of a solver
optimization and vary as I adjust other values). VLOOKUP won't work
since they are not in ascending order. Any other suggestions?


--
neurotypical
------------------------------------------------------------------------
neurotypical's Profile: http://www.excelforum.com/member.php...o&userid=34719
View this thread: http://www.excelforum.com/showthread...hreadid=544848