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