vlookup + index match

[kieuchau]

Hello,
I am trying to get a value from one table to another. I am having trouble with the formula.
Referencing the example:

Serial Number	Date	Value
1	12/16/16	?
2	8/19/16
3	6/2/16

<tbody>
</tbody>

Serial Number	Start	End	Value
1	1/1/16	12/31/16	50
1	1/1/15	1/31/15	100

<tbody>
</tbody>

Thank you kindly in advance.
KC

 

[easy2understandexcel]

In those particular circumstances you will want to use sumifs like FDibbins suggested...

 

[kieuchau]

Yes, that is what I've concluded to, just wanted to see if there were any other solutions. Thanks again!

 

[Anand Sharma]

Hi

In this case when you want to match data with multiple conditions and between a date range , use sumproduct forumula as

=SUMPRODUCT(--(A2=A9:A10),--(B2>=B9:B10),--(B2<=C9:C10),--(D9:D10))

 

[kieuchau]

Hi

In this case when you want to match data with multiple conditions and between a date range , use sumproduct forumula as

=SUMPRODUCT(--(A2=A9:A10),--(B2>=B9:B10),--(B2<=C9:C10),--(D9:D10))

[FONT=&quot]Darn, I was really wishing this would work but it only returned #N/A for me..[/FONT]