Search and find corresponding values between worksheets

[Rumplestiltskin]

Ok, here's the situation. I have a worksheet that is a master list of all employees with certain employee attributes in one worksheet. In another worksheet, I want to paste a list of employees with some other employee attribute, and then have it find those employees in the master employee worksheet and copy over certain bits of info from that row into this smaller subset worksheet.

For example:

Master worksheet - each row contains Employee name, department, office #, and SSN.

Working sheet - I paste in employee name, manager name.

It then finds each row in the master where the name matches, and grabs department and office# and copies them to the adjacent cells.

[DonkeyOte]

Could you not use a Pivot Table (Master Worksheet as source) - set those fields you wish to use as Filters as Report Filter fields - set other fields you wish to view as Row Labels etc...

If in doubt - post a sample file (dummy confidential info likes names & tel. nos etc...) - outline desired results.

EDIT: on re-reading your post I don't think the PT will suffice given you have pre-determined ee list for whom you wish to retrieve info... apologies

[Rumplestiltskin]

No worries, I started working on my search capabilities instead of my Excel function capabilities and found a thread that gave me what I needed. I'm not much of an Excel user, but sometimes I know it will do what I need, as long as I can find the right functions/macros. What I really wanted to do was compare two attributes from the two worksheets, and just have some sort of flag if the two didn't match. So given a particular employee entry in worksheet 1, I wanted to copy over a particular attribute from the master to the working worksheet, then compare those two cells.

This copies it over:
=IF(ISNA(VLOOKUP(A2,Master!$A$2:$C$23,3,FALSE)),"No match",VLOOKUP(A2,Master!$A$2:$C$23,3,FALSE))


And then I compare:
=IF(B2=D2,TRUE,FALSE)

I then sort the temp spreadsheet and work the with exceptions to fix the issue. It's not the most elegant solution, but it gets the job done.