Hello All,

I'm trying to create a template that I can use to take an income statement out of a basic QuickBooks export and add some other figures where I see fit.

In the attached excel sheet you will see that I'm trying to pull a data field from the QuickBooks export on the left to the template on the right. The two variables are the heading entry for each field and the corresponding month. I know how to do a vlookup for one month but I want to have a formula that is already setup for any month I have at the top of my template.

Can you please help me figure this out?

Monthly Income Template.xlsx