compare and extract using a program. i really need help.

[ayunik]

I have a task at my work whereby it requires me to extract the Staff ID
from one spread sheet to another by comparing the User ID. It is very
time comsuming since there are more than 6000 numbers to copy. Now,
what I want to do is simple, all I want is to extract the Staff ID
from one spread sheet to another in the correct cells. Thats easy but
here is when it gets complex.

Spreadsheet 1
Staff ID
....
....
....
....

User ID
sgfd
soip
stya
swjk



Spreadsheet 2
Staff ID
123
456
789
159

User ID
sgfd
soip
stya
swjk

I just need to know how to start.

Thanks for anyone's help.

ayunik

 

[anilsolipuram]

Need to explain in detail

 

[R.VENKATARAMAN]

pedestrian method is

in sheet 2 the col A is userid and col B is staff id -both with heading rows
in sheet 1 col A is user id with the heading. in B2 type
=VLOOKUP(A2,Sheet2!A1:B5,2,FALSE)
copy B2 down.

is this clear.
change A!:B5 to suit you.


there are other sophisticated methods.