Hello!

If you will so kindly view my data set, I am trying to populate tab 1 with data from tab 2. I would like to be able to pull in Usage data (Tab 2, Col K) into tab 1 based on Building Code (Tab 2, Col B), Service Type (Tab 2, Col E) and Statement Date (Tab 2, Col H). The goal is to populate Tab 1 with this data so it can be update automatically by just uploading new underlying data and no manual editing necessary.

More info: -For Service Type, I only want "EL" code to be included in the calculation, any other codes should be ignored by the formula.
-I am trying to build this template by Building Code so only data relevant to one specific building should be being pulled (the example data set has 3 different building codes)
-I have totaled what the correct usage amount should be that the formula should populate in Tab 1, Cell G12 to try and help clarify a little and also give a check to know if the formula is correct.

Finally, I would like to add in a function using Data Validation or another method if it is easier to create a dropdown menu by Building Code (Tab 2, Col B) in Tab 1 so I can change between different buildings and have all the data change relevant to each building.

I know there is a lot here and if anything is unclear or I left anything out that is necessary to try and do this I apologize in advance. I have been trying to make something work on this for days and am just stuck so any help at all would be appreciated. Thanks so much for taking the time to help!

Sincerely,
BoneyLit

Excel Help 2.xlsx