Lookup Problem

[Kenshin]

Hello friends i have my question in the attachment, thank you for the help



cheers

 

[Hui]

I've no idea?

Your table doesn't have a date field?

 

[azumi]

No it looks a like just looking how to find the date on 1 cell

 

[Khalid NGO]

Hi,

I guess you have missed the date column in your sample file.

Supposed your dates are in column D, try this:
=INDEX($D$2:$D$5,MATCH(A13&B13,INDEX($A$2:$A$5&$B$2:$B$5,),0))

If no duplicate, try this:
=SUMIFS($D$2:$D$5,$A$2:$A$5,A13,$B$2:$B$5,B13)

Regards,