Hi all!
I'm having difficulty nesting a VLOOKUP function inside a SUMIFS function. Excel keeps telling me, "Not trying to type a formula?" However, when I used the same VLOOKUP formula nested inside a SUMIF (not plural) function, it works just fine.
Where might I be going wrong?
Thanks!
=SUMIFS('Current Data'!$P:$P,VLOOKUP(Summary!$C2,'Market Mapping'!$A$3:$B$122,2,FALSE),'Current Data'!$K:$K,'Current Data'!$A:$A,Summary!F$1,'Current Data'!$D:$D,Summary!$B2,'Current Data'!$I:$I,"n")
FormulaIssue.PNG
Bookmarks