Good day!

I was hoping someone could help me with what is probably a very simple
formula. I have a sheet that holds customer data with different products and
prices. On a separate sheet with past customer purchases, I would like to
formula to tell me what the first sheet says the customer should pay today if
they bought that particular product. example:

Sheet 1:
Customer1234 WASTEOIL252 4,000L
Customer1234 WASTEOIL253 500L

Sheet 2:
Customer1234 WASTEOIL252 .05CPL
Customer1234 WASTEOIL253 .10CPL

Any suggestions?
--
Thanks for your help!