=VLOOKUP($B214,INDIRECT($D$2&"Dealer15'!$A$5:$BF$4 98"),$J$2,0)+VLOOKUP($B214,INDIRECT($D$2&"Dealer15 '!$A$5:$BF$498"),$J$2-1,0)

In the above formula, is there a easier way to include multiple months without needing to reference again the $B214 in each part of the statement.

This is something that is needed as soon as possible and the spreadsheet that is pulling the data is almost 2000 lines. So it would be easier if the original VLOOKUP which comes before + sign could simply add $J$2 (referencing December) $J$2-1 (November) and $J$2-2 (October).

$J$2 is a field that refers to the current month in the 2 spreadsheets that import data into the spreadsheet with this formula.

I would then be able to find and replace the formula.



It will be better if we don't have to completely change the formula in this spreadsheet and can somehow get the columns to add and then bring forward into this spreadsheet. In the case of the formula above, it refers to Line B214 in the other 2 spreadsheets and then to columns November & December.

I got the formula to work using it as you see it at the top of the thread. However, now we need to add 3 months together.

There must be a better, more efficient, way, than what I took the time to do with the above formula.

Any assistance will be appreciated.

Would you attach a sample of the file?

I can't provide a copy, however, maybe someone can tell me what is wrong with this formula.

=VLOOKUP($B214,INDIRECT($D$2&"Dealer3'!$A$5:$BF$49 8"),$J$2:$J$2-2,0)

It WORKS, however, the I need this part of the statement $J$2:$J$2-2 to add Month $J$2 + Month $J$2-1 + Month $J$2-2.

But what happens is it only shows one month, Month $J$2-2.

Lotsa luck.