Thread: [Solved] Is there a shorter way to write this formula?
View Single Post
 
Old 03-07-2015, 04:23 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 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.
Reply With Quote