Return Column name from results in grid

[ThisDave]

Hi, I hope yo can help

I've a grid with home team on the y axis and away team on the x. I've each fixture where the teams meet within the grid (so Arsenal v Leicester = 1, Leicester v Arsenal = 31 e.g.)

Arsenal Bournemouth Brighton Burnley Chelsea Arsenal 4 7 37 22 Bournemouth 23 5 14 10 Brighton 29 22 18 24 Burnley 13 38 36 31 Chelsea 5 25 20 1 <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

I'd like a formula which, if I input "Arsenal" in cell b1 and "1" in a2, it will return "Leicester" in b2.

**
I have tried combining an if function with V & H Lookups, or index or match functions, but to no avail.

Obviously each team plays 38 fixtures, and meets each opponent twice.

Essentially I want to replace the Away teams on the x axis with the fixture number, and subsequently the fixture numbers within the grid, with the opponents to make later referencing easier.

Home\/ Away> 1 2 3 4 5 Arsenal Leicester Stoke Liverpool Bournemouth Chelsea Bournemouth Brighton Burnley Chelsea <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

Any help is appreciated

**( I mean, eventually, I'm aiming to input "1" into a cell and have each of the fixtures displayed across a range, but I reckon I can sort that afterwards)

Fixture	1
Home			Away
Arsenal			Leicester
Brighton			Man Utd
Chelsea			Burnley

<tbody>
</tbody>