| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
