dynamic excel table header / column selection

=INDEX(Table_1[Col_A],MATCH(1,INDEX((Table_1[Col_B]=$BB$3)*(Table_1[Col_C]=$BC$3)*(Table_1[Col_X]=$BD$3)),0),0))


Successfully using the above to return Col_A when Col_B, Col_C & Col_X match specific criteria.

Sometimes I want to match Cols B C & X other times B C & Y or B C & Z

How can I dynamically specify which column heading to use X Y or Z
like if $CC1 contained "X" : Table_1[Col_ & $CC1 & ]=$BD$3


Notes:
Even if I wanted to, I can't do this with nested ifs as there are too many options.
Prefer not a volatile option.
I realize what I'm using is an array but it doesn't require Ctrl-Shft-Enter, which I prefer, as it's too easy for a coworkers to forget this requirement.