엑셀 함수식 질문 (Xlookup?혹은 그 외 효율적 방법)
첨부파일 참조하세요.=SUMPRODUCT((LOOKUP(ROW(Sheet1!$B$5:$B$34),ROW(Sheet1!$B$5:$B$34)/(Sheet1!$B$5:$B$34<>""),Sheet1!$B$5:$B$34)=$C4)*(LOOKUP(ROW(Sheet1!$C$5:$C$34),ROW(Sheet1!$C$5:$C$34)/(Sheet1!$C$5:$C$34<>""),Sheet1!$C$5:$C$34)=$D4)*(ISNUMBER(FIND(G$3,LOOKUP(COLUMN(Sheet1!$F$2:$M$2),COLUMN(Sheet1!$F$2:$M$2)/(Sheet1!$F$2:$M$2<>""),Sheet1!$F$2:$M$2))))*(LOOKUP(ROW(Sheet1!$D$5:$D$34),ROW(Sheet1!$D$5:$D$34)/(Sheet1!$D$5:$D$34<>""),Sheet1!$D$5:$D$34)="기초")*(Sheet1!$F$3:$M$3="수량"),Sheet1!$F$5:$M$34)