Cell B2 has a formula setup in it so it enters the team that is in a
different tab into it. I am trying to setup an if formula in cell A2 that
either puts an AL if true or NL if false. For example,

Cell B2 says KC (which is from a formula setup to equal a cell in another
tab).
I type in cell A2 the following:
=if(B2="KC","AL","NL") and it gives me NL. If I override the formula in
cell B2 and just type in KC it works right and gives me AL. Any idea why it
doesn't work when the formula produces KC? Thank you.