Ask Experts Questions for FREE Help !
Ask
    Askme5642's Avatar
    Askme5642 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    May 13, 2008, 08:30 AM
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    May 13, 2008, 09:48 AM
    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?
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
    		  
    #3

    May 13, 2008, 10:51 AM
    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 ;)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Multiple positive ovulation test results [ 15 Answers ]

Hello! This is my first post :)! My husband and I are trying to get pregnant and I've had 5 positive ovulation test results over the last five days :eek: . What could this possibly mean? Thank you.

Limitations of VLOOKUP [ 3 Answers ]

I have a column of values that can't be put in ascending order. 20 55 3 61 2 etc. I want to lookup another value that corresponds to each of these numbers.

View more questions Search