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