You're not going to get the results that you want with VLOOKUP, try looking into 3D SUMIFS.