need your help (URGENT) Pls

  • Thread starter Thread starter h12ra
  • Start date Start date
H

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 :confused:


regards,
HRa
 
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
 
Back
Top