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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Methods to Export Gmail to Text? 1
vlookup for client list 7
Bookkeeping 1
Merging multiple worksheets (selective cells) 1
Populating data from a pull down 1
Numbering data as entered 7
How do I write a formula to obtain information from another spread 1
Automatically entering data 2

Back
Top