Return nothing if criteria is not met
 

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.

Return nothing if criteria is not met
 

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

On Dec 9, 1:54*pm, Gotroots
wrote:
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.

Return nothing if criteria is not met
 

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" wrote:

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.

Return nothing if criteria is not met
 

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.



"Eduardo" wrote:


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" wrote:

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.

Return nothing if criteria is not met
 

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

On Dec 9, 2:56*pm, Gotroots
wrote:
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.



"Eduardo" wrote:

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" wrote:

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.- Hide quoted text -

- Show quoted text -

Return nothing if criteria is not met
 

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)

"Gotroots" wrote:

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.



"Eduardo" wrote:


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" wrote:

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.

Return nothing if criteria is not met
 

I suspect that you can't see my reply.

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

--
Biff
Microsoft Excel MVP


"Pete_UK" wrote in message
...
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

On Dec 9, 2:56 pm, Gotroots
wrote:
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.



"Eduardo" wrote:

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" wrote:

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.- Hide quoted text -

- Show quoted text -

Return nothing if criteria is not met
 

Simple when you know how Brad :)

Your solution worked!

Thank you

"Brad Autry" wrote:

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)

"Gotroots" wrote:

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.



"Eduardo" wrote:


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" wrote:

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.