ertan
01-25-2006, 12:29 AM
I have list of person names (column B ) and corresponding numbers (Column A) in Sheet1 (full list-all the names ) = Main List
and sheet2 just the person names...(partial list) no correspondind numbers..
I would like to lookup - compare names from sheet2 and if they are in sheet1 = Main List
I would like to add those corresponding numbers to them.
Example
Sheet1
MainList
ColumnA
5
3
5
4
3
ColumnB
John
Mark
Edward
Steve
Albert
.....
Sheet2
ColumnB
Mark
Steve
Albert
Desired Result:
3 Mark
4 Steve
3 Albert on Sheet2
Any help wellcome
Regards
and sheet2 just the person names...(partial list) no correspondind numbers..
I would like to lookup - compare names from sheet2 and if they are in sheet1 = Main List
I would like to add those corresponding numbers to them.
Example
Sheet1
MainList
ColumnA
5
3
5
4
3
ColumnB
John
Mark
Edward
Steve
Albert
.....
Sheet2
ColumnB
Mark
Steve
Albert
Desired Result:
3 Mark
4 Steve
3 Albert on Sheet2
Any help wellcome
Regards