I have multiple columns ( that are not side by side) that I need to evaluate for the test "MARKET" in any of the cells
I have created the following formula for a specific cell : (have also tried the INDIRECT function in a Named Range - also no luck)
=IF(COUNTIF(INDIRECT({"I2:I36","T2:T36"}),"MARKET"),"*MARKET","")
The formula will only evaluate the 1st Column (I2:36) correctly - Subsequent columns (T2:36) seem to be ignored
The exact same behavior happened when I tried to set up and use a NAMED RANGE using INDIRECT
Any ideas?
I have created the following formula for a specific cell : (have also tried the INDIRECT function in a Named Range - also no luck)
=IF(COUNTIF(INDIRECT({"I2:I36","T2:T36"}),"MARKET"),"*MARKET","")
The formula will only evaluate the 1st Column (I2:36) correctly - Subsequent columns (T2:36) seem to be ignored
The exact same behavior happened when I tried to set up and use a NAMED RANGE using INDIRECT
Any ideas?