Adding Summation Function to Vlookup Formula

LWest · Aug 6th, 2002, 07:35 PM

I posted this question before, however, the response was not exactly what I needed. As I still haven't figured out a solution, I will try to post the question again, and hopefully I can explain what I am trying to do a little better.

I am trying to add the summation function to a formula that has the vlookup function within it.

Here is an example:

Unit 1 Unit 2 Unit 3 Unit 4
income 5 4 3 2

I am trying to add the income for each of the 4 units using the vlookup function against income. So, my formula currently is as follows:

=vlookup("income",file,inc,2,false)+vlookup("income",file,inc,3,false)+vlookup("income",file,inc,4,false)+vlookup("income",file,inc,5,false)

In my live file; however, excel limits how many of these you can have and I receive a message stating my formula is too long. I thought there would be a way to add the sum function to this, but I cannot seem to get it correct. Any help would be appreciated. Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Aug 6th, 2002, 07:35 PM	#1
LWest Join Date: Jul 2002 Location: Chicago, Illinois Posts: 5	I posted this question before, however, the response was not exactly what I needed. As I still haven't figured out a solution, I will try to post the question again, and hopefully I can explain what I am trying to do a little better. I am trying to add the summation function to a formula that has the vlookup function within it. Here is an example: Unit 1 Unit 2 Unit 3 Unit 4 income 5 4 3 2 I am trying to add the income for each of the 4 units using the vlookup function against income. So, my formula currently is as follows: =vlookup("income",file,inc,2,false)+vlookup("income",file,inc,3,false)+vlookup("income",file,inc,4,false)+vlookup("income",file,inc,5,false) In my live file; however, excel limits how many of these you can have and I receive a message stating my formula is too long. I thought there would be a way to add the sum function to this, but I cannot seem to get it correct. Any help would be appreciated. Thanks!