You can specify the value_if_no_match parameter ... logical tests involving multiple conditions. It also works well when the tests use different logical operators in Excel (e.g ...