I'm using a template called "sales invoice tracker" in Excel 2016. The following is the problem going on here.

As you can see the text is either not showing at all or showing the formula.

The formula it uses is as follows:

```
=IFERROR(INDEX(InvoiceDetails,SMALL(IF(InvoiceDetails[Invoice '#]=rngInvoice,ROW(InvoiceDetails)-ROW(InvoiceDetails[#Headers])), ROW(1:1)), MATCH($C$8, InvoiceDetails[#Headers], 0)),"")
```

Here is a view of the "details" sheet:

Video of what happens in Excel:

`Show Formulas`

by accident? Check the`Formula`

tab in the`Formula Auditing`

group.