Product list to match price list

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

This is the formula for the first one:

VLOOKUP(Sheet2!A2,Sheet2!A42,1)

If this doesn't help I can email u the file.

Thanks very much for your help