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.