Vlookup and sum two colums

[adamdaniel143]

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

 

[Pecoflyer]

To post a sheet click on " go advanced" under a reply thread and click " manage attachments" in the " additional options box

 

[sambit]

Hi adamdaniel,
pl find attached file.

 

[adamdaniel143]

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.

 

[ray777]

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) )"

 

[sambit]

Hi adamdaniel,
for index cum match function. pl check method 3.

 

[sambit]

Hi,
for index cum match function. you can also try method 4.