VLOOKUP with condition

Hi All

I am trying to do a vlookup, but only if it matches another condition, ie, not just bring back the first value it finds whilst descending. If you look at the example attached, I want to bring back a price against the item #, but only the price that also matched the customer. Hope this makes sense!

Cheers

=SUMPRODUCT((Sheet2!$A$6:$A$12=A4)*(Sheet2!$B$6:$B$12=B4)*(Sheet2!$C$6:$C$12)) in sheet1 c4 dragged down
note this would return
36 for D5814 1AIRL30
as
there are 2 entries for
D5814 1AIRL30
14.00 &22.00
is that what you want?

Hi Martin

This does work but there are instances when I want a value brought back without summing (due to the same lookup value, but with differing value range. Please see another example attached. In this I want to bring back a price for an item that has a different price depending on a price break. Can I bring back a specific price, if in another cell the value is greater than or equal to 10 but less than 20 for example. (The example explains it better).

Cheers

=LOOKUP(B4,Sheet2!B4:B7,Sheet2!C4:C7)

Guys, you have done it again!! Thanks heaps