WHat is wrong with this formula
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) = ...
"Sportinus" wrote:
=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.
|