UlvaZell wrote:
I have a spreadsheet that calculates an income statement for a selected
reporting period for various entities. The period is selected using a combo
button from the forms tools which then works in conjunction with a table to
populate a range of cells for Vlookup references. The Vlookups then populate
from a table that has 12 months of data into a table that only has the
current period and the YTD for the same period. SUMIF's then summarize the
selected data into financial statement line item categories.

The problem is that because of the size of the spreadsheet, there are about
60,000 Vlookups that update whenever the period is changed. The recalc time
is about 2 minutes. I'm certain there must be some other way to select
specific columns of data from my main table without using Vlookups, but every
possibility I've thought of has not worked.

Several options get me as far as populatiing data, but not to the point of
automating the population of the data. I guess what I'm looking for is the
functionality of a Vlookup without the processing drawback. Any ideas?

It's not entirely clear to me how the Vlookups "then populate from a
table that has 12 months of data", but for what it's worth

=INDEX(a1:m10,0,3), array entered into a 10-cell column, will return the
3d column of a1:m10)

Alan Beban