Cell Displays Equation Instead of Solution in Array

[BuffaloGuy]

I downloaded an Excel Template for Invoice Tracking. On a sheet titled Invoice, which was originally a protected, I unprotected the sheet to modify some cells and make the file more usable. On a cell that I didn't even change any text on, the array brackets {} disappeared and the solution is no longer displayed, but instead the function that was written is displayed. I tried the CTRL-SHIFT-ENTER method to "activate" the array, but the function is still displayed. The odd thing, this only affects a certain column. Column C has the only affected cells. Cells B9:F33 have similar functions in them, but only Column C, has cells that display the function instead of the solution.

Thoughts?

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

 

[diddi]

check the cell format has not changed to "Text"

 

[BuffaloGuy]

The cell was, and remains, formatted as Custom.

 

[Fluff]

Check that there are no spaces (or any other character) before the = sign.

 

[BuffaloGuy]

No characters of any type before the = sign

 

[Fluff]

In that case, without seeing the workbook, I'm not sure.

 

[RossTattersall]

There is an option in the view settings to display formula instead of results, but to my knowledge it doesn't apply to individual cells.

Is there a circular reference?

 

[BuffaloGuy]

I don't think there is a circular reference, the cell works fine if I leave it alone and don't attempt to modify it. But just clicking in the function box is enough to undo the original function.

When you open a new Excel file and search invoice in the Online Templates search box, the template "Sales Invoice Tracker" is available. That's what I am using.

 

[Fluff]

Which cell is that formula in?

 

[BuffaloGuy]

it happens in cells C9:C33