How to search in formulas and values in Excel

Let’s take a look.

The naming is a little confusing, so let’s take a look at some examples.

Excel’s default setting for “look in” is formulas, and this makes sense in most cases.

In both cases, Excel finds no match, even though we can see the values in the table.

This is because Excel is searching formulaswhat is stored in the celland not the values as displayed.

If we look at the Tax column, we can see this is actually a formula.

So $19.89 is not actually stored in the cell G11.

Now Excel will search values as displayed.

We can find $19.89anddates in March without any problem.