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
Bookmarks