VLOOKUP Fundamentals Video Tutorial

In this video tutorial, we discuss the basic use of the VLOOKUP function – one of Excel’s most popular and useful tools. If you’re intimidated by VLOOKUP, you don’t have to be! To work along with the instruction, download the spreadsheet here: VLOOKUP Exercise Spreadsheet.

Techniques used in this video include:

  • VLOOKUP with FALSE for Exact Matches
  • VLOOKUP with TRUE for Close Matches without going over
  • F4 Shortcut for Absolute References
  • Ctrl + Shift + Arrow Keys for selecting ranges

Leave a Reply

Your email address will not be published. Required fields are marked *