|First, without knowing how your data is laid out, it would be impossible for us to offer any type of meaningful suggestions. We just don't have the details required to test anything or suggest anything.|
There is a link at the bottom of this post. If you click that link you will see the instructions on how to post example data in this forum. Perhaps a short example of your data, including Row numbers and Column letters, would help.
Second, simply based on the text in your post, this almost seems like it will need some sort of "decision making" process where the result is based on the size of the facility, the equipment required, etc. Depending on how complicated that decision making process is, it might not be something that is doable with a formula. It might require some VBA code (a macro) which is much more adaptable when it comes to sorting through a list, using If-Then tests, etc.
Again, the more details we have the better chance we have of coming up with something.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.