If you have the client numbers on both sheets, then any other data on the
same row may be returned using the VLOOKUP method offered by
Roger..........try it, and if you still have difficulty, post back.

Vaya con Dios,
Chuck, CABGx3



"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