Data tips: vlookup and hlookup in Excel
In this video you will learn:
- How to use the VLOOKUP and HLOOKUP functions in Microsoft Excel, to emulate basic relational database functionality in an Excel workbook.
This tutorial uses demonstration data from the fictitious project, The Letters of Bilbo Baggins: A Critical Digital Edition.
Functions shown here were tested in 2019 versions of Excel, on both Windows and Mac.
Links
