Using Match, Index and concatate to populate a fixture table.

Hi Smart people,

I will admit, this one is a little confusing for me and I need some assistance.

Comp List.JPG

I am trying to create a fixture table like in the image, but using the results as formatted below it.

I have completed everything else but would like to add this bit to my over all data entry.

I have tried various combinations on Match, Index mixed with Concatate... but I seem to get odd results.

Can anyone help me with an explanation on how I should be ordering these things..

basically, I am trying to have excell find:

the row labeled team A and then the column labeled Team B.
Search the results that I type in as below the table.
And then concatate them into the fixture table.

Am I trying something crazy or can it be done?

Thank you all in advance for any assistance.

thanks Glenn,

It was just a number and didnt notice it missing..

Here is an updated image

Comp List.JPG

From What I understand, I am probably going backwards with the index and match functions..

Thanks Glenn,

I knew I was confusing myself, I really appreciate the assist. I can stop pulling my hair out now.

Fooz