The LOOKUP() function should do exactly what you want. For the matching
criteria, simply refer to the appropriate cells in your table - that
way, you don't have to keep changing values all over the place if your
weights or rates change.


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=534935