Use Excel's VLOOKUP Function to Build an Invoice
5:11
Added: 3 years ago
From: DannyRocksExcels
Views: 13,689
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (6)

Sign In or Sign Up now to post a comment!

  • how to influence if not put the phrase "false" at the end of this formula?

    FreeExcelFormulas 7 months ago

  • @FreeExcelFormulas

    In the VLOOKUP Function, the 4th Argument (True or False) is optional - not required.

    When you use FALSE - the VLOOKUP will return an "Exact Match" for the value in the leftmost column of the lookup array.

    If you leave the 4th argument out, VLOOKUP will use TRUE as the 4th argument. TRUE is the default value and it will look for the "first closest match" it finds in the leftmost column of your lookup array.

    Danny Rocks

    The Company Rocks

    DannyRocksExcels 7 months ago

  • you save may day m8, nice work

    xxxdaxoxxx 2 years ago

  • Great tutorial

    Very, Very Helpful

    cjodonoghue 2 years ago

  • Nerds rejoice!

    RatBastardHatesYou 3 years ago

  • sir awesome tutorial

    good example awesome explanation

    tirathmistry 3 years ago

Loading...
Alert icon
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