$=$IFERROR$()$ is something that any analyst who actively presents data should take advantage of$.$ Using the previous example, looking for specific text$/$values in a dataset won$$t return a match. This causes a #VALUE error, and while harmless, it is distracting and an eyesore.

Use $=$IFERROR to replace the #VALUE errors with any text$/$value$.$ In the example above, the cell is blank so that data consumers can easily pick out which rows returned a matching value.

Formula:

$=$IFERROR$($FIND$$VALUE$,$SELECT CELL,VALUE$\_$IF$\_$ERROR$)$