matching ids help
How about a simple formula
C2: =INDEX('S1'!B:B,MATCH(A2,'S1'!A:A,0))
--
__________________________________
HTH
Bob
"rodchar" wrote in message
...
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
|