vlookup

  • Thread starter Thread starter Debs242920
  • Start date Start date
D

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
 
Perhaps

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

??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple criteria search 2
Count and Sum Total occurrances of two specific numbers 10
Match & Vlookup Function 1
sumif with a lookup formula 5
Match Last Occurrence of two numbers and Return Date 6
Frequency Formula 5
The sum of multiple returns on a vlookup 3
Match Last Occurrence of two numbers and Count to Previous Occurence 31

Back
Top