Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   Sum multiple Vlookup results

Answer this Question Ask about Spreadsheets
 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old May 13, 2008, 07:30 AM
Askme5642
New Member
Askme5642 is offline 		 
Join Date: May 2008
Posts: 1
Askme5642 See this member's comment history on his/her Profile page.
Sum multiple Vlookup results
Hello,

Is there a function that can sum multiple Vlookup results? I hate doing this to sum 3 Vlooukup results: =VLOOKUP($I3,AFFINITY,7,FALSE)+VLOOKUP($I3,AFFINIT Y,8,FALSE)+VLOOKUP($I3,AFFINITY,9,FALSE)

Thanks,
Gen

Reply With Quote
 
     

Answers
 
 
Old May 13, 2008, 08:48 AM   #2  
JBeaucaire
Software Expert
JBeaucaire is offline
 
JBeaucaire's Avatar
 
Join Date: Jan 2008
Location: (Call me JB) Bakersfield, CA
Posts: 2,175
JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.
Pay to call JBeaucaire for advice ($.75/min)
Call JBeaucaire via Skype™
I'm not sure there is, but what is it about your posted method you find objectionable? If it works and is accurate, what problem does that leave for you?
  Reply With Quote
 
     
 
 
Old May 13, 2008, 09:51 AM   #3  
Curlyben
Administrator
Curlyben is offline
 
Curlyben's Avatar
 
Join Date: Mar 2005
Location: Behind You !!
Posts: 5,722
Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.
Call Curlyben via Skype™
looks good but you need to change it a little:

=SUM(VLOOKUP($I3,AFFINITY,7,FALSE)+VLOOKUP($I3,AFF INIT Y,8,FALSE)+VLOOKUP($I3,AFFINITY,9,FALSE))

Should do the trick
  Reply With Quote
 
     
Answer this Question Ask about Spreadsheets

« Previous Question | Next Question »

Question Tools Search this Question
Search this Question:

Advanced Search
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Questions
Question Asker Topic Answers Last Post
Multiple positive ovulation test results prettymonkey Women's Health 2 Feb 20, 2008 06:32 PM
Issues with VLOOKUP Amyunimus Spreadsheets 0 Jul 20, 2007 09:46 AM
Limitations of VLOOKUP Amyunimus Spreadsheets 3 Feb 21, 2007 12:41 PM
using VLOOKUP in excel Johnno63 Spreadsheets 0 Oct 18, 2006 10:02 PM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 03:04 AM.

Content Relevant URLs by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.