Trouble with Index & Match
 

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

Trouble with Index & Match
 

=INDEX(C2:C100,MATCH(1,(A2:A100="ID")*(B2:B100="st atus"),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)



--
Regards,

Peo Sjoblom



"Arturo" wrote in message
...
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

Trouble with Index & Match
 

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

"Arturo" wrote:

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

Trouble with Index & Match
 

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


--
Regards,

Peo Sjoblom



"Arturo" wrote in message
...
Found a good example here too.
http://www.contextures.com/xlFunctio...tml#IndexMatch
Example 4

"Arturo" wrote:

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