Hi everyone,
I got below formula that works ok but I need to amend it in a way that (after matching up) instead of looking up for B4 and bringing the value in column 3, look up for B4 and bring a sum of all available values in column 3 that match B4 because there might be more than one cell that match B4.
=IF(AND(BZ$2=Result!$A$1,CA$3=Result!$B$1),VLOOKUP($B4,Result!$A$2:$C$170, 3,FALSE))
Thanks a lot
Bookmarks