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 conversation is currently closed to new comments.
I sent an email to their tech support to see if their software will do the trick. If not, will get my programmer to work the solution. Thanks for your put.
Yes Carlos VLookup can get me the True, False between the two values. The real challenge, which I'm thinking will require some additional code outside Excel, is populating the name field when True. Appreciate the help.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Data Comparison - Lookup