Forum Discussion
Searching Column A for 3 different values
I am trying to create a formula that will search each row in Column A for one of 3 values : When the text is "Level: C" , I want "Coverage" to appear in Column E until the text "Level: L" is fou...
=IF(AND(COUNTIF($A$2:A2,"Level: C")=0,COUNTIF($A$2:A2,"Level: L")=0,COUNTIF($A$2:A2,"Level: R")=0),"",IF(A2="Level: C","Coverage",IF(A2="Level: L","Level",IF(A2="Level: R","Region",F1))))You can try this formula which seems to work in my sheet. I entered the formula in cell F2 and filled down.