Excel Lookup functions, explained: XLOOKUP / LOOKUP / VLOOKUP / HLOOKUP [IGCSE ICT 0417]

Описание: 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
   • Excel References, Relative, Absolute and M...  

Link to the resources used in this tutorial:
https://www.dropbox.com/scl/fo/wiucrf...