Is there a shorter way to write this formula?

		Microsoft Office Forums > Microsoft Excel > Excel
Is there a shorter way to write this formula?

FAQ

Thread Tools

Display Modes

03-07-2015, 04:23 PM

babs1234

Windows 7 64bit Is there a shorter way to write this formula?

Office 2010 64bit

Novice

Join Date: Mar 2015

Posts: 3

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 PM.