Filtering Columns Based On Lists

[Analyst 007]

Hi Guys,

I have a large set of data (12,000 Lines) that is a directory of contact information for around 5,000 business. I need to extract all of that contact data from separate excel list of around 500 companies. Is there a way to filter on the "company name" column for all 500 companies on my list at once without having to select each company on the filter drop down?

VLOOKUP wont work because it will only return one value. INDEX/MATCH might work but I am a little unfamiliar with it.
I've also run into this same question at other times and wondered if using a list to filter a column is possible.

Thanks in advance,

Andy

 

[Dan Waterloo]

Please give an example of what you mean? For example, what would be in the list and how do you want it to match the data?

 

[Fluff]

As well as what Dan has said, are you open to a VBA solution, or do you formulae?

 

[Analyst 007]

As well as what Dan has said, are you open to a VBA solution, or do you formulae?

I don't do VBA. I was hoping there may be an advanced filter but can do formulae if needed.

Its really just a one column list of company names that I want to use as the filter criteria. (Both data sets come from the same system, so there shouldn't be any spelling or spacing differences. My master set of data is a regular data table with columns for company name, phone number, extension, email address, address, city, state, zip.

Thanks