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