Compare and Copy

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.

I think you are looking for the VLookup Formula. It looks up a value in a
range of values and returns a corresponding record from the range. If that
is not what you need let me know.
--
HTH...

Jim Thomlinson


"leecone" wrote:

>
> 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.
>
>
> --
> leecone
> ------------------------------------------------------------------------
> leecone's Profile: http://www.excelforum.com/member.php...o&userid=31833
> View this thread: http://www.excelforum.com/showthread...hreadid=515556
>
>

Thanks for the response Jim. I too think the VLOOKUP works for the comparison of values, but the second piece is where I'm stumped

"and when they match, copy and paste the corresponding user name from Worksheet B to Worksheet A adjacent to the appropriate position #."

Thanks for the help.