Search results

If I had time I could automate the whole thing for you with a script. ( ask me in a couple of weeks )

I think you've made the common mistake of storing your source data in presentational format (a matrix with row and column headers) then giving yourself the complication of transforming it. The above range formula is neat, but will need to updated as you add a column for new team A matrix also...