Merging sheets to find repeat customers

[cmax979]

I currently have an excel file with 2 sheets (tab 1 and tab 2). Tab 1 contains an internally generated customer ID number, customer first name, customer last name, customer DOB, and customer address as the column headings. Tab 2 contains a column heading for customer ID number and contains only those customer ID numbers which have reordered a product from us. I want to know if there is a way to create a third sheet that will contain all the column headings found in tab 1, but only for those customers whose customer ID number appears in tab 2. In other words, I want to make a sheet that contains only customers who have re-ordered form us.

[Paul]

Not sure why you want a third sheet when you could just add the formulas to pull in that data onto tab 2, but if that's what you want...

1. Copy the Customer ID column from tab 2 to a new tab (let's call it tab 3).
2. In column B (cell B2 I assume, if headers are in row 1), use the following formula:

=VLOOKUP($A2,Sheet1!$A:$E,COLUMN(),0)

3. Fill that formula across to C2, D2 and E2.
4. Select B2:E2 and fill the formula down as many rows as you have values in column A.

That should take care of it.