If/Then formula?

  • Thread starter Thread starter swent
  • Start date Start date
S

swent

Help please!

Am working on a report that lists employee numbers and employees.
would like to have the employee name autofill when the number i
input........any suggestions?

Apply to board only please~

Thanks!

Swen
 
Hi

look at the VLOOKUP function
basically you need your employeeid in one column & the employee name in
another
then when you enter the employeeid in a cell (in another sheet or whatever)
you can use the VLOOKUP function as follows
=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,false)
which means
lookup the value entered in A1 (ie your employee number) in the table
containing the employee number and employee name (on sheet 2) and return the
information from the 2nd column where there is an exact match.

Hope this helps
Cheers
JulieD
 
Back
Top