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