Forum Discussion
Multiple nested VLOOKUPs in IFERROR
I'm sorry - it's been asked before and looked through the older posts but can't solve my problem. I'm looking to string together a formula which will look for a given name in 4 different "boxes" an...
=SUMPRODUCT((($B$3:$B$10=B16)*($F$3:$F$10))+(($H$3:$H$10=B16)*($L$3:$L$10))+(($N$3:$N$10=B16)*($R$3:$R$10))+(($T$3:$T$10=B16)*($X$3:$X$10)))
Instead of vlookup you can apply sumproduct.
- Thanks Quadruple Pawn,
I have never used SumProduct before, so will look at what else I can use it for.
