Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHat is wrong with this formula
=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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHat is wrong with this formula
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 "Sportinus" wrote in message ... =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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
Can anyone tell me what is wrong with this formula please?! | Excel Worksheet Functions | |||
What is wrong with formula? | Excel Worksheet Functions | |||
What is wrong with this IF formula | Excel Discussion (Misc queries) | |||
Can anyone tell me what's wrong with this formula? | Excel Worksheet Functions |