Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |