My formula skills are pretty rudimentary so for give my extra-lengthy formula below. I'm sure there is a way to make it cleaner. If so, feel free to let me know. However, that's not my issue here.

Basically, this formula will add a couple columns based off of a name in another tab. If the name matches, a little addition is done and the answer is populated into the cell. My issues is that if the name is duplicated on the 'e-plan' tab, this formula will not work. I don't get an error, I simply get a blank cell.

Any ideas on how to make sure that it calculates duplicate names also?

The file itself is fairly large so I'm hoping the formula alone will give someone enough to work off of.

=IFERROR(IF(COUNTIF('e-plan'!$H$2:$H$33,B17)>=2,INDEX('e-plan'!$I$2:$I$33,MATCH(B17,'e-plan'!$H$2:$H$33,0))+INDEX(OFFSET('e-plan'!$I$1,MATCH(B17,'e-plan'!$H$1:$H$33,0),0):'e-plan'!$I$33,MATCH(B17,OFFSET('e-plan'!$H$1,MATCH(B17,'e-plan'!$H$1:$H$33,0),0):'e-plan'!$H$33,0)),IF(COUNTIF('e-plan'!$H$2:$H$33,B17)=1,(INDEX('e-plan'!$I$2:$I$33,MATCH(B17,'e-plan'!$H$2:$H$33,0))),""))+IF(COUNTIF('e-plan'!$H$2:$H$33,B17)>=2,INDEX('e-plan'!$J$2:$J$33,MATCH(B17,'e-plan'!$H$2:$H$33,0))+INDEX(OFFSET('e-plan'!$G$1,MATCH(B17,'e-plan'!$H$1:$H$33,0),0):'e-plan'!$J$33,MATCH(B17,OFFSET('e-plan'!$H$1,MATCH(B17,'e-plan'!$H$1:$H$33,0),0):'e-plan'!$H$33,0)),IF(COUNTIF('e-plan'!$H$2:$H$33,B17)=1,(INDEX('e-plan'!$J$2:$J$33,MATCH(B17,'e-plan'!$H$2:$H$33,0))),"")),0)