Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Stop entering data manually and start using Excel's VLookup

Loading...

Sign in or sign up now!
7,505
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 11, 2008

When you are creating data forms - e.g. Payroll Statements, use Excel's =VLOOKUP() function to populate the data fields.

You will save time and be sure that the latest changes in your data are reflected on your forms.

I invite you to visit my website - http://thecompanyrocks.com/excels
to view all of my Excel Training Videos.

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (4)

Sign In or Sign Up now to post a comment!
  • @xxxstefanirrrr

    I have several videos here on YouTube that show you how to do this. Search on my YouTube Channel for "Data Validation" - Pick from a List.

    If you send me a YouTube Message (rather than a comment) I can direct you to the appropriate videos for this.

    Danny Rocks

    The Company Rocks

  • Hi danny. Quick question. We do our invoices manually in excel and we would like to input our customers info in a way that when we enter the customer info it will come from a drop down list and we can just click it. Please help.

  • @snowwarrier20

    Thank you for the compliment.

    Danny Rocks

    The Company Rocks

  • nicely explained..

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more