Return nothing if criteria is not met

[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.

 

[Pete_UK]

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

 

[Eduardo]

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)

 

[Gotroots]

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.

 

[Pete_UK]

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

 

[Brad Autry]

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)

 

[T. Valko]

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

 

[Gotroots]

Simple when you know how Brad

Your solution worked!

Thank you