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