Forum Discussion
how to substitute or mask "#VALUE!" on the fly without creating a intermediate cell/formula
I have the following formula: =IF(SEARCH("XYZ", Product),Product, 0) where: Product is a named area in a spreadsheet. From time to time the pattern "XYZ" is not found (and it should be so) and th...
Not sure what exactly you are trying to achieve, but perhaps this one is what you need:
=IFERROR(SEARCH("XYZ", product), 0)- Thx
I used
=IF(IFERROR(SEARCH("XYZ", Product), 0),Product,0)
and now it works (again I wanted the 'answer' w/o an in-between calculation.
Your formula gives 0 or 1 and not the name of the product or 0
Thanks again
