I need help to make formula that based on name and date will place in cell information from another cell.
Everything works until i have same user more than one time. my formula is :
=IF(AND(G$1>=$B$3:$B$19,G$1<=$C$3:$C$19,MATCH($F3,$A$3:$A$19,0)),$D$3:$D$19,"")
=VLOOKUP(SUMIFS($D$12:$D$17,$B$12:$B$17,"<="&G$10,$C$12:$C$17,">="&G$10,$A$12:$A$17,$F12),$A$2:$B$8,2,FALSE)
Not the cleanest one but it works in old versions of Excel...
Notice in cell A2 There is a 0 value associated to a blank value. To avoid the formula returning zeros you must deactivate option: