Scott:
I'm fairly sure that VLOOKUP, used properly, will satisfy your request.
So, please post your formula(s) and we'll see what the forum can do for
you.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=507020