General discussion
January 4, 2006 at 08:59 AM
doyle.cone

Excel Data Comparison – Lookup

by doyle.cone . Updated 20 years, 8 months ago

I have two separate worksheets. Worksheet 1 contains a list of position #s (personnel). Worksheet 2 contains a list of position #s (Column A) with individual names (Column B). My task is to compare position #s in the two worksheets and when they match, copy and paste the corresponding user name from Worksheet B to Worksheet A adjacent to the appropriate position #. Any help would be appreciated.

This discussion is locked

All Comments