Find First Match in Range Return Header Value

Ok, I have a range of cells. I give 3 examples. I am looking for the first cell to match my text, in the example its "Y". And return that column header value.
In Group A the search range is B3:D13. The First Y is in D4. I need the value of that column header, which is in D2, which is 9.
In Group B the search range is G3:I13. The First Y is in I3. I need the value of that column header, which is in I2, which is 8.
In Group C the search range is L3:N13. The First Y is in N6. I need the value of that column header, which is in N2, which is 7.
The example shows the first "Y" is always in the 3rd column that won't always be the case.

I have looked that these 2 solved post but they did work.
https://www.excelforum.com/excel-gen...ell-value.html
https://www.excelforum.com/excel-for...this-text.html

You can use this formula for Group A:

=IFERROR(INDEX(B2:D2,MOD(MIN(IFERROR(MATCH("Y",B3:B13,0)+0.1,100),IFERROR(MATCH("Y",C3:C13,0)+0.2,100),IFERROR(MATCH("Y",D3:D13,0)+0.3,100)),1)*10),"not found")

For Group B use this:

=IFERROR(INDEX(G2:I2,MOD(MIN(IFERROR(MATCH("Y",G3:G13,0)+0.1,100),IFERROR(MATCH("Y",H3:H13,0)+0.2,100),IFERROR(MATCH("Y",I3:I13,0)+0.3,100)),1)*10),"not found")

and for the final Group C you can use this:

=IFERROR(INDEX(L2:N2,MOD(MIN(IFERROR(MATCH("Y",L3:L13,0)+0.1,100),IFERROR(MATCH("Y",M3:M13,0)+0.2,100),IFERROR(MATCH("Y",N3:N13,0)+0.3,100)),1)*10),"not found")

They are virtually the same - only the ranges change to suit each Group.

Hope this helps.

Pete

Thanks for the rep - I presume from your comments that this worked fine for you.

Pete