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

=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

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

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