Assuming you change the FEEDERS column in table 14 to "Feeder" to fit with your data validation then you can use the following formula.
Also your Watt/Sqm does NOT need to be entered as an array.
Just copy and paste this in and hit enter.
Also I would recommend correcting the spelling of industrial and creating a NEW list for Feeder and Service AND the Building types, so you can have them in alphabetical order. then you can just use your new lists for the validation instead of the raw data like you are doing now.
Bookmarks