Lookup and add additional information

[ertan]

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

[Bob Phillips]

=INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0))

[ertan]

Thanks Xld,

But this formula just gives the names.

I need number and name ..

Output should be:

3 Mark
4 Steve
etc..

Regards

[Bob Phillips]

I assumed that you had the names already. Do you have nothing
? If so, just use

=Sheet1!A1

and

=Sheet1!B1

and copy down

[ertan]

I guess I didnt explained clearly, my mistake sorry.

I attached sample..
Regards