Excel Gurus,

I need some help. I'm trying to create a power and cooling calculator that imports the most current data from the department of energy electricity costs by state and sector table and then lets me use drop downs in order to create a multidimentional lookup.

source:
http://www.eia.gov/electricity/month...?t=epmt_5_06_a

I use that URL and grab the main table in a web query into a dedicated sheet in a workbook, set to update on file open.

From there I have a cover sheet that performs a list from the items in the census division (column A) in one cell and a list of the sectors across the top from a third sheet. (I chose to create a list on a third sheet so I don't have double spaced responses in the drop down that I get when I try a horizontal list validation on import for the energy sectors)

Anyhow

What I'm going for here on the cover sheet is drop down and select maryland. Then drop down and select Industrial. And the third cell return the cost of electricity based on maryland's current Industrial cost per kWhr as an example.

Thanks in advance for any help the group can provide.