My table has 19 rows and 11 columns. The leftmost column is a list of 17
buildings. The second column is a unit type (sq. ft.). I have 9 columns
with numbers. The top two rows are descriptions of Utility and Condition
(Good, Average, Fair, etc.) Using VLOOKUP, IF and AND, I can nest functions
to use 7 of the 9 columns.
VLOOKUP(Text81,Buildings!G5:P21,IF(AND(Dropdown4=B uildings!P3,D32=Buildings!P4),10, IF ................[ET CETERA]

I need at least to cover the 9 combinations of Utility and Condition but
I've met the limit of my ability.

Thank you for your help!