카테고리 없음
[뛰어나다] 오류를 반환하는 sumproduct 및 vlookup
행복을전해요
2021. 2. 19. 18:10
이거 한번 해봐:
=IFERROR(SUM(INDEX('[IJM current plan.xls]LO calcs'!$AV$12:$BO$147,
MATCH(D261,'[IJM current plan.xls]LO calcs'!$AU$12:$AU$147,0),0)),0)
+IFERROR(SUM(INDEX('[IJM current plan.xls]OF calcs'!$BD$12:$CA$147,
MATCH(D261,'[IJM current plan.xls]OF calcs'!$BC$12:$BC$147,0),0)),0)
출처
https://stackoverflow.com/questions/22079902