|
|
|
|
#1
03-07-2015, 04:23 PM
|
|||
|
|||
Is there a shorter way to write this formula?
Is there a shorter way to write the following formula:
=VLOOKUP($B328,INDIRECT($D$2&"Dealer15'!$A$5:$BF$4 98"),$J$2,0)+VLOOKUP($B328,INDIRECT($D$2&"Dealer15 '!$A$5:$BF$498"),$J$2-1,0) Your assistance will be very appreciated. 
|
|
#2
03-09-2015, 12:16 AM
|
|||
|
|||
|
I always prefer to put in 3 formulas in separate columns. It's hard to say if this can be shortened without seeing a sample book.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Shorter VBA for creating borders for cells
|
mbesspiata | Excel | 2 | 07-28-2014 12:37 PM |
|
How to create shorter docs from large base template?
|
Preloader | Word | 13 | 10-19-2013 09:39 PM |
| write need help and copy write need help on another page auto | wykoems | Word | 2 | 07-25-2013 07:56 AM |
|
Write Test
|
dkub | Word VBA | 1 | 07-21-2012 09:01 PM |
|
How can I write the following (whole) formula in a single cell?
|
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode