BuffaloGuy
New Member
- Joined
- Dec 5, 2017
- Messages
- 28
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?
Thoughts?
Excel Formula:
=IFERROR(INDEX(InvoiceDetails,SMALL(IF(InvoiceDetails[Invoice '#]=rngInvoice,ROW(InvoiceDetails)-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($C$8, InvoiceDetails[#Headers], 0)),"")