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