I am dumb with vlookups so please help

[qwazar1981]

Hi Everyone,

I am absolutely dumb with lookup formulas. And do not want to loose on this stupid spreadsheet more time than needed so I am counting on you.
Yes it will look very easy to most of you, but my brain is tired tonight and I cant keep up with it.

Thanks a LOT LOT LOT !

question.xlsx

[samba_ravi]

Welcome to the forum
=SUM(INDEX((TRIM($B$2&" "&$B$3:$B$16&$C$2&" "&$C$3:$C$16)=G$2&$F3)*$D$3:$D$16,0))
Try this and copy across

[samba_ravi]

or can try
=SUMPRODUCT((TRIM($B$2&" "&$B$3:$B$16&$C$2&" "&$C$3:$C$16)=G$2&$F3)*$D$3:$D$16)

[TMS]

Not VLOOKUP in this case, SUMIFS.

=SUMIFS($D$3:$D$16,$C$3:$C$16,SUBSTITUTE($F3,"Task ",""),$B$3:$B$16,--SUBSTITUTE(G$2,"Month ",""))

Regards, TMS

[qwazar1981]

Thx tms - the last one included what ifs. And thats why I needed
'