look up values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to look up two values within a table on form a date and another from a
product and display an answer e.g

A B C D
1/1/07 01 CARD 32
1/1/07 01 BOX 35
1/1/07 02 CARD 33
2/1/07 02 BOX 30
2/1/07 02 BOX 33
I need to lookup all instances of card on the 1/1/07 and all instance of box
on the same date. And the same for all subsuquent days. Then I need to add
column D. So the value for Card for the 1/1/07 would be 65........
 
I need to look up two values within a table on form a date and another from a
product and display an answer e.g

A B C D
1/1/07 01 CARD 32
1/1/07 01 BOX 35
1/1/07 02 CARD 33
2/1/07 02 BOX 30
2/1/07 02 BOX 33
I need to lookup all instances of card on the 1/1/07 and all instance of box
on the same date. And the same for all subsuquent days. Then I need to add
column D. So the value for Card for the 1/1/07 would be 65........
Click to expand...

Maybe:-

=SUMPRODUCT((A1:A5=E1)*(C1:C5="Card")*(D1:D5))

Where E1 is the date you are looking for.

Mike
 
Back
Top