Hello Vadiraj
Worksheet function VLOOKUP is what you need.
Regards
Pascal

"Vadiraj" a écrit dans le message de
...
Hi all,
I have the excel sheet which has two sheets
first one has employee number ,The second one has employee
number,DOB,Salary,Address and all the records have some
values for each employee number

as i enter some employee number on first sheet and say
enter the respective DOB,salary,address need to be copied
from second sheet and be positioned in first sheet in
respective columns

can anybody help me in achieving this

Thanks in advance

Regards
Vadiraj