VLOOKUP with condition

=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