Reading and displaying numbers from one sheet to another

I have a list of client names with their respective numbers on a sheet 1 and I have a list of jumbled client names with the names repeated in the next sheet 2. I would like to retrieve the client number from the data sheet and display the number for that respective client name in the second sheet

Sheet 1:

Client Number Client Name
1 David
2 Tom
3 Suzan
4 Richard
. .
. .
. .
. .



Sheet 2:
Client Name Client Number
Richard
Tom
David
Suzan
Richard
Tom
David
.
.
.

I want the program to retrieve the client number for the names from sheet 1 and display it accordingly in sheet 2
For eg:- it should retrieve Richard's client number as 4 from sheet 1 and display digit 4 next to richard's name in the client number column.

I have attached the sample document....

Thanks
Ramanan

In column N and copied down:

Please Login or Register  to view this content.

FYI you can achieve the same with a basic INDEX/MATCH

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

the above is non-volatile - the prior suggestion is not given use of INDIRECT
(for more info. on Volatility see link in sig.)

Another alternative given the value being returned is Numeric would be a basic SUMIF

=SUMIF(Sheet1!$B:$B,$M2,Sheet1!$A:$A)