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

Excel Formulas - using simple VLookup for invoice

Loading...

Sign in or sign up now!
45,070
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 26, 2008

Using VLookUp to reference Invoice Items from a list.

Introduction to the VLookup function - using a Purchase Invoice as a worked example.

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (11)

Sign In or Sign Up now to post a comment!
  • given 24 numbers, (97,101,139,41,37,31,29,89,23,­19,8,13,131,19,73,97,19,139,79­,67,61,17,113,127)taken 5 at a time, generate the unique combinations add up to 200. so, num combination to test 42504, optimal results 27 groups of 5 numbers : example (8-17-37-41-97)-(8-13-37-41-10­1)

    etc. this program is in java. How is possible to do this in EXCEL 2003 .

  • combinatorial problem -- given the 24 numbers taken 5 at a time, which unique combinations add up to 200?

  • Very useful..Thanks

  • what happens if you sell widgets and spanners in the same order #?? how can i get that information?

  • Brilliant, well explained, thank you so much

  • Thank you, this helped me out a great deal!!! Cheers!

  • or press F4 to fix the range instead of hard coding the $ sign

  • Thanks SOOOOO much! you just helped me massively on my IT homework :-D

  • You are a legend. Thanks mate

  • Its a nice information

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