I have an array of data in a table that is broken down by month across the top row and the expense I had for a particular line item across subsequent rows. I have also created a template in another sheet with a single input cell for the month and all of the same expense areas as defined by the table array.
I would like to be able to put in the month at the top of my template form and have it return the expenses for that month in the categories listed.
It seems like an easy two reference lookup problem except that my data are listed in both columns and rows and not entirely across columns as many of the posts I have read trying to solve similar questions.
Thanks.
I would like to be able to put in the month at the top of my template form and have it return the expenses for that month in the categories listed.
It seems like an easy two reference lookup problem except that my data are listed in both columns and rows and not entirely across columns as many of the posts I have read trying to solve similar questions.
Thanks.
