Index/Match Formulas - Search/Filter Based on Specific Criteria

Please see the attached sample file.

So for example - Say that the columns that are peach in color or columns B - E are my filters and I only want to select rows that have the following:

223, Structural Steel, OS and I only want to return the cost codes with these specified criteria

As in I want to take information from this "Sample" set based on criteria as listed above and I want to return all associated values within that criteria on another sheet.

Essentially what i'm doing is filtering data and placing it on another page. I'm trying to automate several reports that i need to generate on a monthly basis.

These reports are specific to criteria as listed above.


The unique identifier to each row is the "cost code" column. Costs are associated with each code. These codes have been classified (columns B - E) and the period and JTD (Job to Date) data has been compiled in columns G - N.

I hope this makes sense.

I am on the brink of automating all of my reports. This will cut out several days of work if I can begin to index properly. I just need a helping hand.

All help is greatly appreciated.