If Or Or Or Statement Then

[elsaidmi]

Good afternoon,

I need to write a formula that does the following:

If cell is (#### or #### or any letter combination) then put "MA"
if cell is (#### or ####) then put "SC"

#### stand for a combination of a few numbers.

Haven't been able to figure it out. Thank you!

 

[Mackers]

You have two columns selected from your tab (H and I) where the MATCH() function should be across a single column. If you have two columns of values to check, you should use two separate statements, so:

=IF(OR(NOT(ISERROR(MATCH(D19,'OC Helper'!$H$3:$H$20,0))), NOT(ISERROR(MATCH(D19,'OC Helper'!$I$3:$I$20,0)))),"M","OTHER")

Does that help?

Edit: no problem, hope that works for you and let me know if it breaks.