I have a spreadsheet with repeating columns headers and then under these, sub headers. Something similar to this: ARARARECECECOEHWOEHW1091092998104388710729 What I'd like to do is effectively be able to find the column where the value in the first row is AR and the value in the second row is E. Can this be done with a formula?

RMF40 For example: The formula in B10 is =XMATCH(1, (A1:F1=B8)*(A2:F2=B9))

Forum Discussion

Copper Contributor

Oct 09, 2024

I have a spreadsheet with repeating columns headers and then under these, sub headers. Something similar to this:

What I'd like to do is effectively be able to find the column where the value in the first row is AR and the value in the second row is E.

Can this be done with a formula?