Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return nothing if criteria is not met
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return nothing if criteria is not met
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return nothing if criteria is not met
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return nothing if criteria is not met
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return value based on criteria | Excel Discussion (Misc queries) | |||
Return Totals from Certain Criteria | Excel Worksheet Functions | |||
return value based on two criteria | Excel Worksheet Functions | |||
How to return min, mean, max using criteria? | Excel Worksheet Functions | |||
How to return min, mean, max using criteria? | Excel Worksheet Functions |