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...
In C16:
=SUMIF($B$3:$B$10,B16,$F$3:$F$10)+SUMIF($H$3:$H$10,B16,$L$3:$L$10)+SUMIF($N$3:$N$10,B16,$R$3:$R$10)+SUMIF($T$3:$T$10,B16,$X$3:$X$10)
Fill down.
Thanks Hans ! Looks much easier than Vlookup...