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...