Data Vaildation with Cell Changes

I need help with the attached excel worksheet. I am trying to pull a number from the table using two drop down lists. I need a drop down list for Feet, a drop down list for Building and I need the cell next to these drop down list to automatically pull the number from the table.

Please help!!

Thanks!

My attached spreadsheet has two drop down lists that are derived from the table above the two lists. I need the number from the table to automatically be entered into that cell when the two drop down lists are selected. For example, If I choose from the Feet drop down list: 0-15 and a building letter from the Builidng drop down list: A, I need the number from the table to automatically be shown: 0.32.

Can anybody help?