Learn all about the Lookup functions, where and how to use them, their advantages / disadvantages and where each one falls short. Why was the XLOOKUP function created and how to use it. In this tutorial i also cover the new SPILL feature. The tutorial is covers all the Lookup functions required for the Cambridge ICT 0417 practical exam paper 3.
0:00 Introduction
0:52 Understanding what a LOOKUP function is used for
2:43 LOOKUP function Vertical lookup
8:32 LOOKUP function Horizontal lookup
10:38 VLOOKUP Function Approximate Match
17:37 HLOOKUP Function Approximate Match
19:37 Where do VLOOKUP and HLOOKUP fall short
23:21 VLOOKUP Exact Match
26:33 HLOOKUP Exact Match
27:34 Using the result of the Hlookup in a calculation
28:19 Using Multiple Workbooks and Spreadsheets
33:37 Why the XLLOOKUP function was created
36:21 XLOOKUP Function vertical lookup
41:20 SPILL feature
43:10 XLOOKUP Function horizontal lookup
Link to the tutorial on References
[ Ссылка ]
