Pulling data from multiple worksheets

[parthur]

I have one worksheet with a listing of client numbers and names. I would
like to be able to type in a client number on another worksheet and have the
client name automatically populate.

 

[Jim Thomlinson]

Look at the Vlookup function or the combination of Index / Match. Vlookup
will be a little more straight forward for a first timer but Index / Match is
generally speaking a more flexible and less error prone solution.