Collate data from one spreadsheet into another spreadsheet

A

Anthony

I have two spreadsheets. Spreadsheet A has a list of 500 clients. Spreadsheet
B has a list of over 5000 members.

I need to know if any of the 500 clients in Spreadsheet A appear in
Spreadsheet B, then collate this data in a new spreadsheet.

We can assume the members' first name and surname are in separate columns.
There is also a column with each member's account number.

Is there a formula that can locate and extract the data I need?

Thanks
 
J

Jacob Skaria

Suppose you have the members account number in ColA of both sheets; then try
the below in Sheet1 (500 records) which will check the membership number in
ColA of Sheet2 (5000 records)..and return the text "Found" or return
blank...Copy the formula down and once done you can sort the formula column
and copy paste the data to a different sheet...

=IF(COUNTIF(Sheet2!A:A,A1),"Found","")

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting a cell value 2
Linking data in MS Word into Excel 5
Creating a Chart on form from selected data in query. 0
Mail Merge query 1
Menu Macro Not Executing - Need Help 1
import data from several spreadsheets into one spreadsheet 2
Need assistance with creating spreadsheet to keep track of $ colle 6
Filtering data from a non-continuous list 3

Top