Forum Discussion
LOOKUP FORMULA BASED ON HEADERS
Brilliant, this is now working! When I was using the INDEX & FUNCTION before, I was selecting the entire array, so that must of been why it didn't work.
The application is for use within an a financial statement report. The example I sent shows how the TB data would be formatted within the report.
I'm trying to set it up, so when the user enters the relevant period end date, the formulas will automatically pull in the correct data for the relevant period.
I'm in the process of giving all worksheets and workbooks an efficiency drive makeover, so any input would be very welcome.
Thanks again for your help.
I'm in the process of giving all worksheets and workbooks an efficiency drive makeover, so any input would be very welcome.
Well, without knowing a lot more it would be entirely presumptuous to offer suggestions. Who the user(s) is (are) going to be for example.
In general, though, the layout you had seemed less than functional for the long term. To keep adding monthly data as a new column works for a while, but there is a limit to columns; and long before that, just navigating the screen becomes unwieldly.
Most databases are better thought of as rows and rows of data with the different fields of distinct types of data reflected in the columns. A set of rows, with both account number and month as separate fields in each row (along with other monthly data) would still be searchable and amenable to summarization by account, by month, by other characteristics ...
