need your help (URGENT) Pls

[h12ra]

hi,

I want when i enter the (staff name) in "A" column direct in "B" column
appears the (Staff no) i tried to use the if function but its not
working.....pls help me


regards,
HRa

 

[ryanb.]

Do you mean that you would like to have the staff number pull in
automatically?

 

[J.E. McGimpsey]

If you have a table of names and staff numbers elsewhere (say on
Sheet2) then use VLOOKUP. For example:

Sheet2:
A B
1 Jane 00001
2 George 00342
3 Bill 00014
....

Then in your input sheet:

A1: Jane
B1: =VLOOKUP(A1, Sheet2!A:B,2,FALSE)

will return 00001