vlookup
 

if i have two spreadsheets in a work book,
lawson employee list
employee bi-lingual skills
the lawson sheet has the employees listed by name (last, first) in column a
and their id# in column b but the bi-lingual employees skills sheet doesnt
have the ID#, which i would like to place in column B.
how do i use v lookup to search by name (column A) and get the corresponding
employee id's (column B) from the lawson employee sheet and have that placed
into column B of the Employee bi-lingual skills sheet?
--
thanks in advance

vlookup
 

=VLOOKUP(A2,'employee bi-lingual skills'!A:B,2,False)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"jcontrer" wrote in message
...
if i have two spreadsheets in a work book,
lawson employee list
employee bi-lingual skills
the lawson sheet has the employees listed by name (last, first) in column
a
and their id# in column b but the bi-lingual employees skills sheet doesnt
have the ID#, which i would like to place in column B.
how do i use v lookup to search by name (column A) and get the
corresponding
employee id's (column B) from the lawson employee sheet and have that
placed
into column B of the Employee bi-lingual skills sheet?
--
thanks in advance