View Single Post
 
Old 03-03-2015, 05:36 PM
babs1234 babs1234 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Mar 2015
Posts: 3
babs1234 is on a distinguished road
Default

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.
Reply With Quote