Sep 27 2018 02:29 PM - edited Sep 28 2018 06:38 AM
I have a file like the one attached.
I am trying to get the formula:
=IF(COUNTIFS(A4:F4,"*"&A2&"*",A4:F4,"*"&B2&"*")>=1,":D",":c")
To return the cell address where the statement is true (instead of the silly ":D").
For instance in that file I would want it to return the value "A4" since that is the cell where the 2 conditions of the countifs were true.
How can this be done?
Edit:
I've included another excel file that better reflects this edit.
Sep 27 2018 02:58 PM
Sep 28 2018 06:30 AM
Sep 30 2018 09:02 AM
Two files with different setups.
It is still not clearer.