Return nothing if criteria is not met

  • Thread starter Thread starter Gotroots
  • Start date Start date
G

Gotroots

I want to avoid "No Match Found" to return if there is no value in "C"

=IF(ISNA(MATCH(C362,'Uses and Features A'!$B:$B,0)),IF(ISNA(MATCH(C362,'RHS
additions'!B:B,0)),"No Match Found",C362),C362)

Thank you if you can help with this.
 
Just leave that string empty, then, like this:

=IF(ISNA(MATCH(C362,'Uses and Features A'!$B:$B,0)),IF(ISNA(MATCH
(C362,'RHS additions'!B:B,0)),"",C362),C362)

Hope this helps.

Pete
 
Hi,
just replace "No Match Found" with ""


=IF(ISNA(MATCH(C362,'Uses and Features
A'!$B:$B,0)),IF(ISNA(MATCH(C362,'RHSadditions'!B:B,0)),"",C362),C362)
 
There are records in "C" where "No Match Found" will be applicable.

It is only when there is no value in "C" that "No Match Found" should not be
displayed.
 
Try this:

=IF(C362="","",IF(ISNA(MATCH(C362,'Uses and Features A'!$B:$B,0)),IF
(ISNA(MATCH(C362,'RHS additions'!B:B,0)),"No Match Found",C362),C362))

although I suspect that you can't see my reply.

Hope this helps.

Pete
 
This answer seems a bit simple, but couldn't you just do:

=IF(C362="","",IF(ISNA(MATCH(C362,'Uses and Features
A'!$B:$B,0)),IF(ISNA(MATCH(C362,'RHS additions'!B:B,0)),"No Match
Found",C362),C362)
 
I suspect that you can't see my reply.

Yep, it's broke..........again! Since early yesterday afternoon.

--
Biff
Microsoft Excel MVP


Try this:

=IF(C362="","",IF(ISNA(MATCH(C362,'Uses and Features A'!$B:$B,0)),IF
(ISNA(MATCH(C362,'RHS additions'!B:B,0)),"No Match Found",C362),C362))

although I suspect that you can't see my reply.

Hope this helps.

Pete
 
Back
Top