Vlookup and sum two colums

adamdaniel143

New member
Joined
Dec 8, 2014
Messages
2
Reaction score
0
Points
0
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

Capture.JPG
 
To post a sheet click on " go advanced" under a reply thread and click " manage attachments" in the " additional options box
 
Hi adamdaniel,
pl find attached file.
 

Attachments

  • Book1.xlsx
    10.2 KB · Views: 21
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.
 
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) )"
 
Hi adamdaniel,
for index cum match function. pl check method 3.
 

Attachments

  • Book1.xlsx
    10.5 KB · Views: 16
Hi,
for index cum match function. you can also try method 4.
 

Attachments

  • Book1.xlsx
    10.8 KB · Views: 20
Back
Top