|
|
#3
03-03-2015, 05:36 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 VLOOKUP Formula?
|
ekeithjohnson | Excel | 6 | 08-28-2014 01:16 PM |
|
I think I need an IF/AND & VLOOKUP formula here
|
Catbert | Excel | 18 | 08-25-2013 07:38 PM |
| vlookup not working | jolinchew | Excel | 3 | 08-10-2013 05:24 PM |
| IF + VLOOKUP formula help | skyline255 | Excel | 0 | 09-19-2012 05:05 PM |
| Help with VLOOKUP formula | pattyr | Excel | 6 | 08-20-2012 02:20 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode