To post a sheet click on " go advanced" under a reply thread and click " manage attachments" in the " additional options box
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
![]()
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.
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.
Hi,
for index cum match function. you can also try method 4.
Bookmarks