IF= Function not recognizing defined name.

[Ianseconds]

Ok, so I have a really easy problem here im sure someone can help with.

Attached you will see an excel file with 6 columns.

We enter data into all of these columns, but the ones im concerned with when using the formula is column C (SBU CODE) and column F (CONTACT)
I created the following IF= function in column F.

=IF(C2={"AAB","AAF","AAJ","AAL","AAS","AAX","LON","OFF"},BNYM EMEA Tax and Documentation,Enter Contact)

What I want to happen, is when the user enters any of the following 3 combinations of letters into column C, it will show up with the contact BNYM EMEA Tax and Documentation, which the use will then know who the defined contact is. If it is any OTHER 3 letter combination, it will say ENTER CONTACT IN COLUMN G, or something like that.

My problem is, im not entirely sure this code is correct. I have all 3 logic tests, and the true and false values, but it says NAME% when i press enter. I've went in and defined the names AAB, AFF etc, bu tstill does not work.

Can someone help?

[Ron Coderre]

You need to put quotes around the text you want to display.
Without the quotes, Excel tries to find a defined name with that text and returns an error.

Try this:

Please Login or Register  to view this content.

Does that help?

[Ianseconds]

ugh. thank you. it took longer for me to type out than you to solve. ahah.

Thanks again.