<div>
There is nothing in this formula which would take hours to calculate.<br />
Are you having too many formulas on the sheet?<br />
How many rows of data you are having on the sheet?<br />
What is the size of your file?
</div>


There is nothing in this formula which would take hours to calculate.
Are you having too many formulas on the sheet?
How many rows of data you are having on the sheet?
What is the size of your file?

<div>
I would think that the amount of data is the problem. If each row contains formulas then they are all having to calculate.
</div>


I would think that the amount of data is the problem. If each row contains formulas then they are all having to calculate.

<div>
Yes each row has that index formula. Any other way to write it?<br />
<br />
Kelly
</div>


Yes each row has that index formula. Any other way to write it?

Kelly

<div>
That was just a sample. The actual formula is 800000 rows. I will try the above and get back to you. Thank you for the suggestion!
</div>


That was just a sample. The actual formula is 800000 rows. I will try the above and get back to you. Thank you for the suggestion!

<div>
<div class="content wysiwyg-content">
I have the following Excel formula, however, it is taking hours to calculate. Is there any alternative?<br />
<br />
=IFERROR(INDEX($J$3:$J$27,<wbr />MATCH(1,IN<wbr />DEX((G$3:G<wbr />$18=C8)*(H<wbr />$3:H$18&lt;=B<wbr />8)*(I$3:I$<wbr />18&gt;=B8),),<wbr />FALSE)),0)<wbr /><br />
<br />
Thank you-<br />
Kelly
</div>
</div>


I have the following Excel formula, however, it is taking hours to calculate. Is there any alternative?

=IFERROR(INDEX($J$3:$J$27,MATCH(1,INDEX((G$3:G$18=C8)*(H$3:H$18<=B8)*(I$3:I$18>=B8),),FALSE)),0)

Thank you-
Kelly

Excel Formula Alternative

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.