Long formula using IFERROR and VLOOKUP returning #NAME?

Hi, back again and still hoping one day I know enough to offer help and not just ask for it.

Trying to use this:
=IFERROR(VLOOKUP($A1,'[Academies & Foundation Spreadsheet.xlsx]Nurseries'!$A:$Q,2,FALSE),IFERRROR(VLOOKUP($A1,'[Academies & Foundation Spreadsheet.xlsx]Primaries'!$A:$Q,2,FALSE),IFERRROR(VLOOKUP($A1,'[Academies & Foundation Spreadsheet.xlsx]Secondaries'!$A:$Q,2,FALSE),IFERRROR(VLOOKUP($A1,'[Academies & Foundation Spreadsheet.xlsx]Specials'!$A:$Q,2,FALSE),IFERRROR(VLOOKUP($A1,'[Academies & Foundation Spreadsheet.xlsx]PRUs'!$A:$Q,2,FALSE),0)))))

it returns a value from the first reference sheet 'Nurseries' but if it cannot find it on that sheet, it returns a #NAME? error. Any clues?

I think I responded to you in the past. You have IFERRROR (i.e. 3 Rs) in a few places.

Hope this helps.

Pete

Sorry guys, must have opned the wrong spreadsheet and copied the wrong one. Thanks for your patience