copy data from other sheets

  • Thread starter Thread starter Vadiraj
  • Start date Start date
V

Vadiraj

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
 
Hi Vadiraj
assumption: your employee number is a unique number (no double entries
in the second sheet) then you can use VLOOKUP:
Assumptions:
- cell A1 on sheet one stores a employee number; cell B1 should be
filled automatically with the salary from sheet 2.
- The data on sheet starts in cell A1 and has the column order as
described in your example (employee no., DOB, Salary, Address)
use the following formula in B1:
=VLOOKUP(A1,'sheet2'!$A$1:$D$999,3,0)
this will search for the employee number and returns the third column
in this range (that is your salary). For further information regarding
VLOOKUP have a look at the Excel helpfile

HTH
Frank
 
Back
Top