WHat is wrong with this formula

S

Sportinus

=IF('11th game'!B(MATCH(A2,'11th game'!B20:B34,0)+19)=Sheet1!A2,COUNTIF('11th
game'!C25:N25,Sheet1!C1),)

11th game is a worksheet name. Excel does not like '11th game'!B The
MATCH returns what I expect. Any help is appreciated.
 
P

Pete_UK

Try it this way:

=IF(INDIRECT("'11th game'!B"&MATCH(A2,'11th
game'!B20:B34,0)+19)=Sheet1!A2,COUNTIF('11th game'!C25:N25,Sheet1!C1),"")

Hope this helps.

Pete
 
B

bpeltzer

You can't form the address in this manner. Excel is trying to pass the
result of the Match function as an argument to the function '11th game'!B.
Try instead =if(index('11th game'!B:B,match( ... )+19) = ...
 
Top