Pulling data from multiple worksheets

P

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.
 
J

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.
 
Top