Help With Word Based Excel Formula Using IF/OR Statement

[mhickman]

Hello everyone, so this is what I have so far but this formula does not work for what I am trying to accomplish, can someone help?


=IF(OR(QQ:="Alton","Alamo",["Pharr")”McAllen”)


Basically what I need Excel to do is to render the word "McAllen" in column "V" based off of weather or not there is a match in column "Q" of "Alton", "Alamo" or "Pharr". If column "Q" does not match "Alton", "Alamo" or "Pharr" then I need column "V" to remain blank.


Please Help.


Also, I am using Excel 2013

 

[NeonRedSharpie]

=IF(OR(Q1="Alton",Q1="Alamo",Q1="Pharr"),"McAllen","")

 

[mhickman]

Awesome, thank you NeonRedSharpie but now I've hit another snag, can anyone please help?

I'm wondering is there a way to use multiple if statements in one cell? So please let me try and explain what I am trying to accomplish and then I will show you my current formula.

Like before I am trying to accomplish something very similar but a bit more complex.

Basically what I need Excel to do is to render the word "McAllen" in column "V" based off of weather or not there is a match in column "Q" of "Alton", "Alamo" or "Pharr". If column "Q" does not match "Alton", "Alamo" or "Pharr" then I need column "V" to remain blank.
-or-
If the words "Alpine" or "Alamogordo" are in the "Q" column then the "V" column needs to render "El Paso"; if neither "Alpine" or "Alamogordo" are in column "Q" then again column "V" would need to remain blank.

Here is my current formula:

=IF(OR(Q:Q="Alton",Q:Q="Alamo",Q:Q="Pharr"),"McAllen","") =IF(OR(Q:Q="Alamogordo",Q:Q="Alpine"),"El Paso","")

I don't even know if this is possible but if it is it would save me a huge deal of time.

Thanks again!

 

[NeonRedSharpie]

=IF(OR(Q:Q="Alton",Q:Q="Alamo",Q:Q="Pharr"),"McAllen",IF(OR(Q:Q="Alamogordo",Q:Q="Alpine"),"El Paso",""))

 

[mhickman]

=IF(OR(Q:Q="Alton",Q:Q="Alamo",Q:Q="Pharr"),"McAllen",IF(OR(Q:Q="Alamogordo",Q:Q="Alpine"),"El Paso",""))

This worked flawlessly, thank you very much Neon!!!