I've been stuck on this for hours, any excel wizards know of a way to simplify this problem?

I have a spreadsheet that calculates the gas rate based on what area it is located in (there are 24 areas). Instead of making multiple nested if statements with vlookups embedded, is there any easier way to do this? Perhaps VBA or an array function?

See attached excel spreadsheet. Gas rate is calculated in column E3.

Forecasting Master Excel Help.xlsx

Thank you