If and or

[NRD]

Hello,

I am fairly sure this has been asked before but after hours of searching I have not found anything

I need to create a formula that does the following:

Lets say cells a1 and a2 is populated with data from a drop down menu that has the potential to match data pre-populated in cell B1 or B2

I want something along the line of:

If A1 and A2 = B1 OR if A1 = B2 then display "x"

(X is always the same)

but i cannot for the life of me work out how to do this.

Please, is anyone able to help. I have spent about 5 days on and off trying to crack this

Thanks in advance

Neal

[Jonmo1]

Try

=IF(OR(AND(A1=B1,A2=B1),A1=B2),"x","")

[TMS]

=IF(OR(AND(A1=B1,A2=B1),A1=B2),"X","")


Regards, TMS

[NRD]

Thanks chaps

Will try tonight when back at home

br