How do I write this excel cell formula?
In Row 1 is a list of words and they each correspond to an "!" or an "X" in Row 2. Only one word is given an "!".
[A] [B] [C] [D] [E] [F]
Row 1: This is a list of words
Row 2: ! X X X X X
In a result cell, I want to display the word corresponding to the "!".
So the formula for this cell would accomplish:
IF (Row2_value is "!") THEN (Show Corresponding Word Here)
In this example, it would produce the word "this" because that is what corresponds to "!".