IF Condition statement for Final Status

[Rushendra]

Hi Team,

If condition Required formula
1. If yellow fields = People, process, Technology, Out of scope is blank then final out should be blank.
2. if under people any text is entered then in the same row heading name should come under Final out come.
3. in the same way same condition is applicable for yellow colour fileds heading name should get updated in final status
4. could not go futher formula which I have entered in H2.

Regards
Rk

[JeteMc]

Try this array entered formula* in H2:

Please Login or Register  to view this content.

Note that when first entered it will yield a #Value error.
1) Press the F2 key
2) Press Ctrl, Shift and Enter simultaneously
You may then copy the formula down.
As no directions were given as to what should be the final outcome if two of the cells in a row had a value, I went with the first one. (i.e. 2-July, Xyz)
Let me know if you have any questions.

[kvsrinivasamurthy]

In H2, then drag down.
=IFERROR(INDEX($D$1:$G$1,MATCH("*",$D2:$G2,0)),"")