Extract List Based on multiple criteria

[Herbiec09]

Good afternoon All,

I am looking for help with a formula to extract a list from a database based on 2 criteria. My data is on the tab "Database", and list needs to be on a "summary" sheet.

I have placed the 2 criteria in cells A1 &A2 on the summary sheet. Criteria A1 corresponds with values in column A on the Database sheet and criteria in A2 corresponds with values in column H on the Database sheet.

Any assistance would be greatly appreciated.

H

 

[Joe4]

Take a look at Advanced Filters.
See: http://www.contextures.com/xladvfilter01.html

 

[Herbiec09]

Take a look at Advanced Filters.
See: http://www.contextures.com/xladvfilter01.html

Thanks Joe,

But I am looking for a formula

Thanks

 

[Joe4]

It may be a hard for anyone to come up with that without seeing what your data and expected results look like.

There are tools you can use to post screen images. They are listed in Section B of this link here: Guidelines for Forum Use.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.