Value depends on several conditions: VLOOKUP, SUMIFS or another function?

[Darko11]

I have a counting table w/several columns (in Google Sheets):

So far, the price depends on single condition (Product), with VLOOKUP function

=((C2<>"free sample")*VLOOKUP(B2,Sheet2!B$2:C$4,2,FALSE))

Sheet2 contains:

This gives me price for every Payment Method except for Free sample (where price is 0 since it is free).

I'd like that Price depends on Product, Payment Mathod and Client.

eg. Wholesale will have one price for Product A when paying with cash (2€) and different when using card (3€).

Hope I made it clear enough.

 

[Excel_Fann]

Hello
Your request is not logical.
Why would the price also depend on the client?
Logical would be:
-Different products have different prices
-And if payed with different payment methods then a charge is added

 

[bebo021999]

Use Filter instead of VLOOKUP

=filter(Sheet2!$C$2:$C$3,Sheet2!$A$2:$A$3=A2,Sheet2!$B$2:$B$3=B2,Sheet2!$D$2:$D$3=C2)

Untitled spreadsheet

docs.google.com