Ahmad920Copper ContributorAug 02, 2020vlook up on multiple drop down lists SOLVED -Please see the table 1 below to calculate cost in the Table 2 according to variable values in the cells ( K4,L4,M4 ) ,using vlookup formula thanks! vlook up.xlsx11 KB
TheAntonyIron Contributor to Ahmad920Aug 02, 2020Ahmad920 , here's a variation using SUMIFS: =SUMIFS($G$7:$G$19,$C$7:$C$19,K8,$D$7:$D$19,L8,$E$7:$E$19,M8)
