How do I find a column number based on the values in two rows?

I have a spreadsheet with repeating columns headers and then under these, sub headers. Something similar to this:   AR AR AR EC EC EC O E HW O E HW 10 9 10 9 2 9 9 8 10...