If/Then formula?

[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

 

[JulieD]

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

 

[swent]

Thanks

 

[JulieD]

you're welcome

get back to us if you need more assistance

cheers
JulieD