Working with Multiple drop down lists

Im working on a data base. I have a spread sheet that has a column for each region, ie. Edmonton, Calgary, Red Deer etc (these would also be the headers), Each row under the columns represents a fee for a service. So Carpentry, electrical, Plumbing. The fees are different for each region.

I want to be able to plug in "Edmonton" into my master data base and have all the fees for the different services show up underneath. And then I want to be able to change the same cell to "Calgary" and it changes to the calgary fees.

I will be later using formulas based on those fees in the main database.

Thanks for your quick reply. I had never used the Offset before so its great to learn something new.

Cheers