Pulling data from multiple worksheets

  • Thread starter Thread starter parthur
  • Start date Start date
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.
 
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.
 
Back
Top