VLookup with sumproduct problem

i am using formula =VLOOKUP(D3,'4MAN FORM RESULTS'!Z$2:AA$5,2,FALSE) on sheet '4man fixtures and results' cell E3 to find team name and returns value of their points scored in col AA

then on next sheet '4man setting' i have the formula
=SUMPRODUCT(('4man Fixtures and Results'!D$3:D$276='4man Setting'!$C4)*('4man Fixtures and Results'!E$3:E276>'4man Fixtures and Results'!F$3:F$276))

c4 CONTAINS THE TEAM NAME AGAIN AND columns E3:e276 and F3:f276 contain the two teams points scored

if i remove the formula on first sheet and just enter a numeric value everything works fine, but using the combined formulas in cell on '4man setting sheet' i just get #n/a returned.

has anyone got any ideas how i can get round this one??

Many thanks

nigel

for those that looked many thanks but i found my error on the 4man fixtures and results sheets i had values of #n/a so sumproduct was returning that value,
i added IFERROR(VLOOKUP,D3,'4MAN FORM RESULTS'!Z$2:AA$5,2,FALSE),"")

AND ALL IS FINE AGAIN