Iserror Match if one of two cells includes text

[rsmeyerson]

I am trying to return a value if one of two cells includes text by using "IF(ISERROR(MATCH" formula. I've added the OR function to try to do this but a value is not being returned even if one of the two cells includes text.

Here is my formula:

=IF(ISERROR(OR(MATCH(B172,'[SheetName.xlsm]Sheet1'!A:A, 0),MATCH(B171,'[SheetName.xlsm]Sheet1'!A:A, 0))), "", "Adj New:")

Thank you for your help.

 

[Aladin Akyurek]

Aladin's formula worked. I only had to reverse <"Adj New:",""> at the end of the formula for proper true/false result. Thank you very much to all who replied. I appreciate your help.

You are welcome.