vlookup

J

jcontrer

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?
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top