I'm trying to pull a result from 2 different tables based on multiple criteria. I've posted a couple other times for table help but can't seem to make those examples fit this specific case. The attached example shows the two tables and 4 data entry fields that a user would complete. I'd like to do this in a one step formula, but can't figure it out.
If small building, use charge based on units in table A3 to C8
If Large building, use charge based on limit in table A11 to C21
If Small Building has "YES" for extras, must use charge for large building based on limit in table A11 to C21 (this is the part that breaks my brain)
Tables to be hidden and locked, users to only see and edit A23 to B26
I'm open to doing it in multiple steps or perhaps reformatting the tables or inputs so long as I get the same result.
Help appreciated! Thanks.
Bookmarks