Cross reference 2 lists. Count matches on 2 lists. Help please!

[islesnyanks88]

Hello, I have a project for work and am not sure how to complete it with Excel 2013.

I have 2 lists. List A is a list of 3000 target companies from a client. List B is a list of 140,000 members in our database.

I need a count of how individuals from List B that are in each of the 3000 companies in list A. Need how many members we have from each of these 3000 companies.

Anyone know what tools features I need to use?
How to use these features?
Any specific tutorials I can view?

Any help is appreciated.

[HaHoBe]

Hi, islesnyanks88,

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. http://www.excelforum.com/excel-gene...re-to-use.html.

Ciao,
Holhger