Index Match Issue - Two Columns with Different Data

[almostframps]

I'm currently trying to use the Index Match function to look up values in two columns and then move the associated value in another column to another sheet, but can't currently make it work. Sheet 1, that I'm taking the values from is displayed below -

[TABLE="width: 400"]
<tbody>[TR]
[TD]Home Team[/TD]
[TD]Away Team[/TD]
[TD]Match Points[/TD]
[/TR]
[TR]
[TD]Arsenal[/TD]
[TD]Leicester[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]Brighton[/TD]
[TD]Man City[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]Burnley[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]Crystal Palace[/TD]
[TD]Huddersfield[/TD]
[TD]105[/TD]
[/TR]
[TR]
[TD]Everton[/TD]
[TD]Stoke[/TD]
[TD]95[/TD]
[/TR]
</tbody>[/TABLE]

And what I want to do is copy the points for each match into the rows for both the home and away teams on the other sheet, so in Sheet 2 below Arsenal and Leicester would have 120 in the match points column, Brighton and Man City would have 80, etc.

[TABLE="width: 300"]
<tbody>[TR]
[TD]Team[/TD]
[TD]Match Points[/TD]
[/TR]
[TR]
[TD]Arsenal[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Brighton[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Burnley[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Crystal Palace[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Everton[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Huddersfield[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Leicester[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Man City[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Stoke[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Now I'm not able to put all the teams in the same column in Sheet 1, hence why I'm not using VLOOKUP, because there are numerous other formulas in the document based on who is playing at home and away and I need to keep the teams in those positions in sheet one.

All the explanations about MATCH and INDEX haven't really answered the question. I've tried a variety of different combinations but have deleted them all because none worked. Any help would be greatly appreciated.

 

[AhoyNC]

Maybe something like this:

Excel Workbook
	A	B	C
1	Home Team	Away Team	Match Points
2	Arsenal	Leicester	120
3	Brighton	Man City	80
4	Chelsea	Burnley	90
5	Crystal Palace	Huddersfield	105
6	Everton	Stoke	95
7
8
9	Team	Points
10	Arsenal	120
11	Brighton	80
12	Chelsea	90
13	Crystal Palace	105
14	Everton	95
15	Leicester	120
16	Man City	80
17	Burnley	90
18	Huddersfield	105
19	Stoke	95
Sheet

 

[almostframps]

That worked a treat, thanks very much!

 

[AhoyNC]

You're welcome. Thanks for the feedback.