If and then formula

[Roo007]

If you could help with the formula real quick I’d appreciate it. In cell A1 I have a drop-down list of states example AZ, TX, NY, NJ. And sell A2 I have drop-down list with letters a BOO, TRX, ETC.
And cell A3 I needed to function as: if A1 contains AZ, CA, NY, or TX & A2=BOO then A3 will say TRUE or YES or something like that.

 

[Fluff]

How about

=AND(A2="BOO",OR(A1={"AZ","CA","NY","TX"}))

 

[Roo007]

Thanks but where does A3 come in on the formula?

 

[Fluff]

That's where you put the formula.

 

[Roo007]

Ok, it worked. I guess when i typed it, i messed something up. But when I copied it, it worked. Thank you!!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Roo007]

I hit the check mark as a solution. Do I need to do anything else?

 

[Fluff]

No, nothing else needs to be done.

 

[Roo007]

One more thing plz. Can a box pop up on cell A3 if true without a macro?

 

[Fluff]

No, but if you just want to bring it to somebodies attention, you could use conditional formatting to highlight the cell