confusing error in vlookup

[Sheepkin_Coat]

I am using the following website to make a sports table

http://exceltemplate.net/tutorial/cr...tanding-table/

i have got to step 22 and when i put in the following formula

Please Login or Register  to view this content.

it should put how many games are played, this works for the first three teams (i am using 4 teams to test)

i cannot not get this to work, but it works if i download the sheet from the web site

[Harribone]

I think it is the sheet reference which isn't working for you. If your sheet is called "Table" the formula should be:

Please Login or Register  to view this content.