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

=VLOOKUP($I3;$Table.$A$3:$AF$6;COLUMN()+4;0)

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:

=VLOOKUP($I3;'Table'!$A$3:$AF$6;COLUMN()+4;0)