Hello everyone.
I have an interesting problem and need the groups help to solve. Objective is to concatenate a variable (a text value representing columns like "AF" or "BA") inside a formula to make it a dynamic search.

This formula works fine.
=IF(SUMPRODUCT(('CT IPT Schedule'!$K$5:$K$302="Failed")*('CT IPT Schedule'!AA$5:AA$302<>""))>0,"X","")

I want to replace the column values "AA" in the formula with a text value representing the column i want to search, example "BF" or "X" (which is a column in another tab to search) to make the formula dynamic. Don't know how to replace the text "AA" with my column variable. Using "&" does not work. Ideas how to do this.

Thanks,
Kevin Smith