INDEX & MATCH Formula

For Excel Tables, an Index/Match formula would look something like this:

=INDEX(Table1[ColumnHeader1],MATCH(Sheet1!$A10,Table1[ColumnHeader2],0))

Without seeing how your data is setup, it is hard to give you more help beyond that.

Ok, I have attached an example of my spreadsheet.

To explain this a bit -

Tab 1 "Budget vs Analysis" is a template I created to better illustrate the data in Tab 2 "BvA'.

Tab 2 "BvA" is a downloaded report from a finance system that comes out exactly as it is in this worksheet.

My goal is to have Tab 1 be a functioning template that I can just plop the downloaded report into the worksheet, set a table name to the worksheet, and have the formulas in the template to the rest.

The report is much larger than just this set of data so it would be great to have a formula to pull in the data from the downloaded report automatically. This report is pulled on a monthly basis so the data entry and clean-up gets tedious.

Thank you for your help!