WHat is wrong with this formula

  • Thread starter Thread starter Sportinus
  • Start date Start date
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.
 
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
 
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) = ...
 
Back
Top