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.
