vlookup

[Debs242920]

Hi

Any help would be greatly appreciated i have a worksheet which i nee
to lookup two different criteria which looks something like this

Source Size Packout
cmbwm7 60-80 76
cmbwm7 50-60 72

i can get a result for cmbwm7 but not for the specified size

Thanks in advance

De

 

[JE McGimpsey]

Perhaps

=SUMPRODUCT(--(A2:A100="cmbwm7"),--(B2:B100="50-60"),C2:C100)

??