vlookup and my league table

I recently decided to try my hand at something new with Excel. Given that I tend to organise quite a few video game tournaments of one kind or another, it seemed natural to try and set a league table up with Excel 2013.

I have managed pretty much to do it but I am struggling with the final piece of the puzzle in my soccer league table after filling in some random national team names and some random results.

My spreadsheet has 3 separate worksheets.

One is a Fixtures/Results sheet where it contains (surprise!) the matches to be played and scores of completed matches.
A Dummy Table sheet which pulls the data from the fixtures table and calculates the rankings for the teams.
And finally the standings table which pulls the data from the Dummy Table so that we can have a nice and easy to read ranked table.

I have managed to get the Standings table to fill in the name of the team for the appropriate rank easily enough. My issue arises when trying to use vlookup to fill in the details (games played, win, penalty wins etx)

I know Im missing something REALLY obvious here but no matter what I do I get stuck with NA.

Still I'm rather proud of what ive managed to do. Its not bad for someone who only ever used the SUM command before!

Attached is the sheet in question!

Good Morning.
See the attachment if I understand your purpose.
Good luck.

Thanks guys for your help so far!

AliGW, I have a slight issue with the formula you provided. It seems after I drag the formula down to fill the rest of the "games played" column it breaks down and I have no idea why. Attached is what happens.

grfanco, thanks for that. It'll work perfectly but if you (or anyone else) can explain what exactly is going on there in the standings table in grfranco's version of the sheet that would be HUGELY appreciated.

Good night, Trumane.
I used the index function together with the match function.
The index function returns an item from a list based on a given line number. As we do not know what this line number is, I used the match function that returns the line number of an item within a range.
For your worksheet, the match function returned the line number that each item in the Team column of the Standings spreadsheet occupied in the DummyTable worksheet.
With this number, it was possible to return each item from the All Games Home Games and Away Games columns from the DummyTable worksheet to the Standings spreadsheet.
Admittedly, AliGW's suggestion to use the vlookup function is completely correct (just a column variation adjustment) as you can see in the attachment I'm going through.
I hope I have clarified and apologize for any inconsistency in the sentences (guilty of the google translator)
Good luck.
GFranco.

Thanks! That pretty well wraps things up on my end.

The only thing to work out now is why I have 2 Korea Republics in my Standings sheet

Thanks AliGW for your updated fix. Delighted to report that it works!

The issue with the ranking of teams (i.e. my 2 Korea Republics) is most likely to be found from DummyTable!AA to AF. What I am TRYING to do is first rank teams by points scored, then goal difference, then total goals scored, then away goals scored and finally by alphabetical order (ie if Australia and Russia were tied even after considering away goals, Australia would be ranked above Russia)