Display Activity instruction based on activities not completed

[cholmes]

I have a list of 6 activites. Have set up formulas to give the activity a score of 0,1,2 (meaning Not complete, Pending and Completed). I want to each activity has a different instuction based on not be complete or pending. Here's an example of what I would like to see.

Name	Activity 1	Activity 2	Activity 3	Activity 4	Activity 5	Activity 6	Results
Chad	2	2	2	1	0	0	Activity 4 is pending please contact us
Sara	2	2	0	0	0	0	Activity 3 is not complete, please contact us

This is the basic idea of what I am thinking of accomplishing.

[jeffr27]

For the results box, you can use this formula: ="Activity "&MATCH(TRUE,INDEX(B2:G2<2,0),0)&" is "&IF(INDEX(B2:G2>0,0,MATCH(TRUE,INDEX(B2:G2<2,0),0))=TRUE,"pending,","not complete,")&" please contact us"

Change the range B2:G2 to fit your needs.

[cholmes]

So if the activities had acutal titles. Such as Sports, math, english, science, music and foriegn language. Is there a way to get the formula to select the header of the true statement as the first part of the result?

[cholmes]

So if the activities had acutal titles. Such as Sports, math, english, science, music and foriegn language. Is there a way to get the formula to select the header of the true statement as the first part of the result?

[jeffr27]

Yes. =INDEX($B$1:$G$1,1,MATCH(TRUE,INDEX(B2:G2<2,0),0))&" activity "&MATCH(TRUE,INDEX(B2:G2<2,0),0)&" is "&IF(INDEX(B2:G2>0,0,MATCH(TRUE,INDEX(B2:G2<2,0),0))=TRUE,"pending,","not complete,")&" please contact us"