Hi all,
Using the Match and & formula, I managed to obtain the row number that match 2 criteria (all the combination of 2 criteria are unique so whenever you try a combination, you will get only 1 row that match these two criteria).
So I get the row number of the particular combination of 2 criteria. What I want know, is the formula to check on the row whenever there is a A and if so, return the column header. There is 24 columns so I need the formula to return all the column headers.
I guess it will involve array formula with Match and Index formula but honestly I can't see how to do it.
EDIT: the columns header start at column C and the row number is between row 4 and 100
Best regards,
Alex
Bookmarks