Extract List Based on multiple criteria

Herbiec09

Active Member
Joined
Aug 29, 2006
Messages
250
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,457
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,582
Messages
5,469,514
Members
406,656
Latest member
Kriscrawford76

This Week's Hot Topics

Top