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