Cell Displays Equation Instead of Solution in Array

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?

Excel Formula:
=IFERROR(INDEX(InvoiceDetails,SMALL(IF(InvoiceDetails[Invoice '#]=rngInvoice,ROW(InvoiceDetails)-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($C$8, InvoiceDetails[#Headers], 0)),"")
 
The formula you posted is looking at ROW(20:20) is that in C20?
 
Upvote 0

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,214,907
Messages
6,122,183
Members
449,071
Latest member
cdnMech

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top