Index formula trouble
 

I have the following formula (I did hit ctrl-shift-enter when entering the
formula) in cell A2 of 30 sheets. In cell A1 there is a name. 4 of my
sheets give me the #N/A in cell A2 while the other 26 work just fine. I have
checked the text in A1 and it matches the text in the MLB SCHEDULE sheet. I
even used the =code(A1) and the codes are the same. If I enter the text in
A1 (on a sheet that doesn't work) from a sheet that works the formula works.
Any ideas what is wrong? Thanks.


=IF(COUNTIF('MLB SCHEDULE'!$A$1:$A$4866,$A$1)=ROWS($1:1),INDEX('ML B
SCHEDULE'!$C$1:$C$4866,SMALL(IF('MLB
SCHEDULE'!$A$1:$A$4866=$A$1,ROW($1:$4862)),ROWS($1 :1))),"")

Index formula trouble
 

If you don't understand my question let me know and I will try and explain it
another way.

"Jambruins" wrote:

I have the following formula (I did hit ctrl-shift-enter when entering the
formula) in cell A2 of 30 sheets. In cell A1 there is a name. 4 of my
sheets give me the #N/A in cell A2 while the other 26 work just fine. I have
checked the text in A1 and it matches the text in the MLB SCHEDULE sheet. I
even used the =code(A1) and the codes are the same. If I enter the text in
A1 (on a sheet that doesn't work) from a sheet that works the formula works.
Any ideas what is wrong? Thanks.


=IF(COUNTIF('MLB SCHEDULE'!$A$1:$A$4866,$A$1)=ROWS($1:1),INDEX('ML B
SCHEDULE'!$C$1:$C$4866,SMALL(IF('MLB
SCHEDULE'!$A$1:$A$4866=$A$1,ROW($1:$4862)),ROWS($1 :1))),"")

Index formula trouble
 

I figured out my problem. The 4862 should be 4866 near the end of the formula.

"Jambruins" wrote:

If you don't understand my question let me know and I will try and explain it
another way.

"Jambruins" wrote:

I have the following formula (I did hit ctrl-shift-enter when entering the
formula) in cell A2 of 30 sheets. In cell A1 there is a name. 4 of my
sheets give me the #N/A in cell A2 while the other 26 work just fine. I have
checked the text in A1 and it matches the text in the MLB SCHEDULE sheet. I
even used the =code(A1) and the codes are the same. If I enter the text in
A1 (on a sheet that doesn't work) from a sheet that works the formula works.
Any ideas what is wrong? Thanks.


=IF(COUNTIF('MLB SCHEDULE'!$A$1:$A$4866,$A$1)=ROWS($1:1),INDEX('ML B
SCHEDULE'!$C$1:$C$4866,SMALL(IF('MLB
SCHEDULE'!$A$1:$A$4866=$A$1,ROW($1:$4862)),ROWS($1 :1))),"")