Formula to pull data with multiple horizontal and vertical criteria

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    I want a formula that pulls the $ amount to display in C6:D15 on the summary tab, from the data tab, based on cost type, project and period, and be able to change the periods in row 5 based on the dropdowns in C5/D5 to change and compare months

  • In "Summary" sheet C6, formula copied right to D6 and all copied down :