Accessing names database

C

cefpe

I would like to create a names data base with an employee ID, first an
last name, and last name in three separate columns.
I would like to access this data base from another worksheet by typin
in the employees ID.
Can this be done and how
 
K

kraljb

It can be done using the Vlookup Formula
Assume: Range of employee ID/Info i
C:\tmp\[Book1.xls]Sheet1!$A$1:$D$100
Assume: You enter employee ID on different workbook in cell $A$1

=VLOOKUP(A1,'C:\tmp\[Book1.xls]Sheet1$A$1:$D$100,*2*,FALSE)
to pull in the information in column B of the employee table

=VLOOKUP(A1,'C:\tmp\[Book1.xls]Sheet1$A$1:$D$100,*3*,FALSE)
to pull in the information in column C of the employee table

=VLOOKUP(A1,'C:\tmp\[Book1.xls]Sheet1$A$1:$D$100,*4*,FALSE)
to pull in the information in column D of the employee tabl
 
C

cefpe

kraljb
Thanks for the code. I assume that the formulae will be palced i
columns B, C & D and will access the data base as you have written.
I'll try it shortly and write back if I have a problem.
Thanks,
C Furta
 
C

cefpe

For some reason I am getting a names error. What would the formula be i
the employees range was in Sheet 1 and the lookup data would be store
in Sheet 2 of the same workbook
 
Top