<div>
Well I'll be darned! I knew it was something simple! Thanks!
</div>


Well I'll be darned! I knew it was something simple! Thanks!

<div>
<div class="content wysiwyg-content">
ref to:<br />
<br />
&nbsp;<a href="https://www.experts-exchange.com/questions/28688174/How-to-Filter-an-Excel-list-using-a-formuls-in-a-cell.html?anchorAnswerId=40821462#a40821462" rel="ugc">https://www.experts-exchange.com/questions/28688174/How-to-Filter-an-Excel-list-using-a-formuls-in-a-cell.html?anchorAnswerId=40821462#a40821462</a><br />
<br />
I tried to replace the Sum Product equation with Index Match equivalent<br />
The {} disappear and the result would not display in the cell.<br />
Why does this happen?
</div>
</div>


ref to:

 http://www.experts-exchange.com/questions/28688174/How-to-Filter-an-Excel-list-using-a-formuls-in-a-cell.html#a40821462

I tried to replace the Sum Product equation with Index Match equivalent
The {} disappear and the result would not display in the cell.
Why does this happen?

MS Excel - Brackets disappear in Index Match equation

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.