Extract List Based on multiple criteria

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*the "report sheet" sheet, where I have placed the 2 criteria. Please see attached spreadsheet.

The formula needs to list all identifiers in the database for a particular person where column H in the database is not "Capex" on the report sheet.

An example of this is found in this Chandoo post, but I struggled to make it work on my data: http://chandoo.org/wp/2014/11/10/for...eward-part-ii/

I have attached the spreadsheet.
*
Many Thanks
*
Herbz

Your main issue is that you have trailing space in Column A of Database. That's probably the reason you are not finding any match.

Try cleaning up Column A or add a space to $A$2 in Report and see if it works.

Thanks for the reply Richard

Would you be able to assist with a formula along the lines of what Chandoo had? This will work out a bit better for me as opposed to a code. I am not that good with code yet, and transplanting the example and using it across workbooks becomes a bit of a challenge.

http://chandoo.org/wp/2014/11/10/for...eward-part-ii/

Thanks

H

Thanks Siva,

It works perfectly.

May you please tweak it for me so that it brings back not just a list, but a UNIQUE list, ie if something appears twice in the database, it only appears once on the list.

Many Thanks