Multiple if statement with vlookup function

[TamIam]

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?

 

[Bob Phillips]

=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)