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