Trouble with Index & Match

[Guest]

Hello,
I have 3 columns.
Columns;
A = ID
B = status
C = data
On another sheet I need to match the ID and Status then return the data.
Each ID has several records each with separate status and data.
Playing with formula currently…

Appreciatively,
Andrew

 

[Peo Sjoblom]

=INDEX(C2:C100,MATCH(1,(A2:A100="ID")*(B2:B100="status"),0))

entered with ctrl + shift & enter



If the data in C is numerical you can use SUMPRODUCT instead


=SUMPRODUCT(--(A2:A100="ID"),--(B2:B100="status"),C2:C100)

 

[Guest]

Found a good example here too.
http://www.contextures.com/xlFunctions03.html#IndexMatch
Example 4

 

[Peo Sjoblom]

Example 4 would do that, however if the values in C are numerical it is
better and easier to use the SUMPRODUCT formula