Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching ids help
hi all,
i have 2 worksheets S1 ------ id, name 1, john 2, cathy S2 ------ id, type 1, email 2, phone Is there a way to add the person's name in the column next to appropriate type of the 2nd spreadsheet, linked by id? Desired result: 1,email,john 2,phone,cathy thanks, rodchar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching | Excel Discussion (Misc queries) | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
Matching | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |