Index Match 2 columns 1 row
Try this:
A10 = cat
B10 = 2008
C10 = box
=SUMPRODUCT(--(A2:A4=A10),--(B2:B4=B10),INDEX(C2:E4,,MATCH(C10,C1:E1,0)))
--
Biff
Microsoft Excel MVP
"deeds" wrote in message
...
I am sure this is out there somewhere...I just can't find it.
A B C D E
Cage Box Kennel
Dog 2008 5 6 7
Cat 2008 4 3 2
Fish 2008 8 9 1
I need to find the number 3:
Cat, 2008, Box=3
How do I get it with Index & Match?
Thanks in advance
|