Sorry I am still having trouble. Sheet 1 has the following information:
A B
1 O 001
2 R 0002
3 R 0002
4 S 0003

Sheet 2 has the following information:
A B C
Client ID Number Last Name
1 O 0001 Doe
2 R 0002 Downs
3 S 0003 Smith
4 B 0005 Barney

I want to find the last name for the numbers in column B on Sheet 1. They
are not always on the same row number.

Thanks,




"Sara" wrote:

Both of the sheets have the same client numbers listed in ascending order.
Is there a way to get the name to match to the number?

"CLR" wrote:

Given only the information you have posted, it cannot be done....neither by
Excel nor by any other method, UNLESS, both lists are exactly the same length
and in exactly the same order........if then, just copy and paste the list
from one sheet into the adjacent column of the other list.

If you actually do have more information on one or the other of the lists,
then the VLOOKUP formula may be employed.

Vaya con Dios,
Chuck, CABGx3



"Sara" wrote:

Hello,

I have two sheets that I am working from. The first one has client numbers
that I want to match with the client name from the second sheet. How would
that formula look?

Thanks,
Sara