Excel help with what if

Hello,


I have all the states in column A and I need to result to display in column B. I need Column B to show "Yes" if column A has: MT, ID, WY, UT, CO, AZ, or MD and "No" if it does not contain any of the above listed states.

For example: If A2 is MT then I want it to display Yes and if not, then I want it to show No in Cell B2. I need the formula so that I can copy it down in column B.

Please help.