matching ids help

  • Thread starter Thread starter rodchar
  • Start date Start date
R

rodchar

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
 
Back
Top