How to use "If" "and" function to match two dates

[Bear]

Hi guys

I want to use a formula to dig out a data, the criteria are required to match two dates. I drafted a formula by using if and functions, but it doesn't work. anyone can help me to fine-tune the formula. A sample file is attached.

Thank you.

 

[Chihiro]

Instead of using IF. Try using below construct. INDEX(Return Range,Aggregate(15,6,ROW(Range)/(Conditon1)/(Condition2),1))

In your case something like...
In J3: Copy arcoss
=IFERROR(INDEX(C$3:C$6,AGGREGATE(15,6,ROW($3:$6)/($A$3:$A$6=$H3)/($B$3:$B$6=$I3),1)-2),"")

 

[bosco_yip]

Or…...........

In J3, enter :

=DGET(A2:D100,C2,H2:I3)

Regards
Bosco

 

[Chihiro]

Woo, a new function I've not used before

 

[Bear]

Chihiro & bosco_yip

Thank you for your help. I have learnt something new from here again. It's cool!

 

[rahulshewale1]

Hii @Bear,


=SUMPRODUCT(($A$3:$A$6=H3)*($B$3:$B$6=I3),$C$3:$C$6)



Regard
Rahul shewale