I have the following formula in cells B2:B163
=INDEX(Schedule!$B$1:$B$1300,SMALL(IF(Schedule!$A$1:$A$1300=$A$1,ROW(Schedule!$A$1:$A$1300)),1))

That formula works fine. However, I have the following formula in cells
A2:A163
=IF(OR(B2="BAL",B2="BOS",B2="NYY",B2="TB",B2="TOR",B2="CWS",B2="CLE",B2="DET",B2="KC",B2="MIN",B2="LAA",B2="OAK",B2="SEA",B2="TEX"),"AL","NL")

For some reason I get NL in all of the column A cells even if the cells in B
are BAL, BOS, NYY, etc. If I just type in BAL (and overwrite the formula)
in cell B2, cell A2 will correctly give me AL. Any ideas why it is doing
this? Thanks