How to find column index on specific row with value in excel

Question

Good morning,

I have sheet1 with a column A containing specific codes on each line.

In another sheet2 I have a table with those same codes but in front of each one of them it is possible to mark a "x" on a certain parts.

What I want to do is mark on sheet1 all the codes that have a "x" in front of them on sheet2.

I tried to do this 2 functions which return me "x" as I wanted:

=IF(MATCH(CONCAT(C13,".",D13),sheet2!C:C,0),IF(MATCH("x",sheet2!G7:BD7,0),"x",""))

=VLOOKUP(CONCAT(C13,".",D13),sheet2!C7:AN11,MATCH("x",sheet2!G7:BD7,0)+4)

But I want, excel to find automatically the column index with the "x" mark without having to manually select sheet2!G7:BD7.

Answer 1

等待大神答复