Calculating a range of values based on 2 factors

Hello I am brand new here and trying to figure out if it is possible to make my life easier with a new file dropped on my desk this afternoon.

I need a way to calculate building rates based selecting the building and the value selected;

I have a list of building construction (fire resistive - protected, non combustible - protected etc)... in cell N8 and the limits in cell O8.

Now what I need to do is calculate the rates in the file attached (cells A5:J21 in my worksheet) based on the building construction and the value/limit I select.

Thanks in advance

what sort of method did you have in mind for selecting your criteria? manual entry, drop down list, etc. ?

There will be problems because there are duplicate headings, if you could solve that issue then this will work
=INDEX($B$8:$J$21,MATCH(O8,$A$8:$A$21,FALSE),MATCH(N8,$B$7:$J$7,FALSE))

Attached is an example

Originally Posted by chrish8

sorry should have mentioned the DROP DOWN list is fire resistive - Protected, fire resistive - Semi etc....

So your sample was not what you meant? or will you be able to do something with the example I attached?

I think your sample is kinda throwing us off here.

Do you already have a drop down list or 2 which you're using to select the main headers, secondary category, and dollar amount?