How to filter out certain state

Hello,



I want to be able to filter out certain states in column B. Column A contain all the states and I want the state: CA, NV, TX, MO, MS, and MI to display a certain word in column B for these states only. How do I get column B to display the word " Vacation" for the states listed above in excel?

Problem A: What is the formula for the above in excel?
Problem B: What is the formula for the above in excel macro if I choose to go this direction?

Thanks!