Problem with an IF And statement - #NAME? Error...

Question

Hi,

I'm having trouble with a statement that i've created in my spreadsheet.  Basically, i'm wanting to do the following: if "San Jose Scale" is selected from a drop down menu in A21 and "5" is entered in J21 then I need it to return either "X Market" or "O Market" in another cell (B28).  The problem i'm having is that it returns #NAME?   

This is the formula i created: =IF(AND(A21=SAN JOSE SCALE, J21=20),"X Market", "O Market")

I think that the formula is not working because I am using a drop down selection - is it possible to make it work by using one? 

By the way, i'm using Excel 2007.

Thank you so much for your help in advance!

Sasha

Answer 1

=IF(AND(A21="SAN JOSE SCALE", J21=20),"X Market", "O Market")

as you are looking for Text.

Answer 2

Thank you!