Change Drop downs to populate multiple values into other cells or return a value of 0

Hi Southward,

Just need a little more help. Reference new attached "Sanitized Facilities Master Schedules vs 2 Part 2". Cyclic drop down was populating the FMSS column, so I added a Cyclic Column as well as a new one RABR. It also appears the Water and Electric are not populating correctly now. I changed the names for the Water and Electric on the DATA sheet, did this have an affect on the formulas?

I have highlighted in Green where I would like the spreadsheet to populate it when the Drop down menu is changed and in Red where it is incorrectly hitting.

Thanks for all your assistance.