Results 1 to 7 of 7

Thread: Vlookup and sum two colums

  1. #1

    Vlookup and sum two colums



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey guys,

    I just want to do a vlookup style command. Iíve also been trying index/match functions but canít quite get the syntax.

    Iíve included a screenshot of what I mean, I couldnít figure out how to upload. What I want to do is lookup a particular date (for example 1/12/2014) and then add the values from columns D and G. In the case of that date the returned value should be 909.7

    Click image for larger version. 

Name:	Capture.JPG 
Views:	21 
Size:	72.8 KB 
ID:	2913

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,599
    Articles
    0
    Excel Version
    2010 on Xubuntu
    To post a sheet click on " go advanced" under a reply thread and click " manage attachments" in the " additional options box

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi adamdaniel,
    pl find attached file.
    Attached Files Attached Files

  4. #4
    Thanks for the tips guys, I ended up just doing something similar to your method 2, sambit. An addition of two SUM,INDEX,MATCH functions.

  5. #5
    Instead of an elongated two index match functions, you can try summing them in a virtual array pointed by index and use match to identify the row record. "=INDEX($D$2:$D$11 + $G$2:$G$11, MATCH(lookup_val,$B$2:$B$11,0) )"

  6. #6
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi adamdaniel,
    for index cum match function. pl check method 3.
    Attached Files Attached Files

  7. #7
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    for index cum match function. you can also try method 4.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •