Over my head...

Here is the situation. I have a workbook, where each worksheet has
pricing data for each state. On the "state" pages the format is
the same.
1-3.9 inches 4-7.9 inches 8-11.9 inches
<2500 sq feet $$$$ $$$$ $$$$
<8000 sq feet $$$$ $$$$ $$$$
20,000-23,999 $$$$ $$$$ $$$$
24,000-27,999 $$$$ $$$$ $$$$

On a separate spreadsheet I have entered the sq feet for each location
(currently over 900 of them)

What I would like to do is have the pricing data automatically update
based on the sq footage that I have entered for each site.

I believe that I need to set up a "range" but to be honest; I have
never really played with that.

Any help would be appreciated.

Thanks so much.