combination from .xls using unique identifier Closed

Question

Hello,  

I have 2 worksheets each with employee information.  1 has all new employees in a time period, and the other contains their personal details (master).  The common identifier for these employees is their SSN (in both worksheets). 

I want to extract a list from the master worksheet (with all related data) of all those new employees and write them to another sheet. 

I'm using excel 2007, but also need the process for a colleague on 2003. 

Thank you in advance 

Configuration: Windows XP / Safari 534.16

RWomanizer · Answer

You "VLOOKUP" to get the required result.

make a temporary column next to SSN in Master Data, use VLOOKUP:

now filter for values not equal to #N/A.

Now copy the data and paster to new sheet.

then delete temp. column.

Hope this will clear to you.

Thanks,

Combination from .xls using unique identifier

1 response

Similar discussions

Subscribe To Our Newsletter!