This video demonstrates how to use the VLOOKUP() and HLOOKUP() functions, and provides examples of how these functions can be incredibly useful in building financial models. The instruction also covers common errors to avoid when using these two functions.

The video references two examples that demonstrate how useful these functions are. Links to the associated workbooks can be found below:

1. Distribution Waterfall Workbook: LINK (for subscribers) LINK (if not a subscriber)
2. Multi Location Model (Franchise Model) Template: LINK