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
<2499 sq feet                $$$$            $$$$            $$$$
2500 - 19,999                $$$$            $$$$            $$$$
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 enter CO (for the state) and 2485 (for the
sq footage) and have it autopopulate the pricing data from the CO
worksheet.

I'm not sure if I need to set up lists, or ranges...I just don't know
what direction to head in.

Any help would be appreciated.

Thanks so much.