=INDEX(Sheet2!C2:C1000,MATCH(1,(Sheet2!A2:A1000=A2 )*(Sheet2!B2:B1000=B2),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

Note that you cannot use a whole column in array formulae (prior to excel
2007), but must use an explicit range.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TamIam" wrote in message
...
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!