Formula based on a chart

I have a chart that needs to be turned into a formula. Essentially you would cross reference by brand and number of rooms to return the number referenced. EX. Hotel A with 300 rooms return "1608".

I would also like to keep a VLOOKUP formula to populate the brand and room count in separate columns that are the reference points for the chart formula. Is that possible? My nested formula is a hot mess (62 lines) and not worth pasting here.

Any help is appreciated.

Chart example