Hellow guys, Welcome to my website, and you are watching Excel Lookup functions, explained: XLOOKUP / LOOKUP / VLOOKUP / HLOOKUP [IGCSE ICT 0417]. and this vIdeo is uploaded by Nicos Paphitis at 2021-10-28T04:00:30-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel Lookup functions, explained: XLOOKUP / LOOKUP / VLOOKUP / HLOOKUP [IGCSE ICT 0417] |
| Video Uploader | Video From Nicos Paphitis |
| Upload Date | This Video Uploaded At 28-10-2021 11:00:30 |
| Video Discription | 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 https://youtu.be/qgankq3WqAE |
| Category | Education |
| Tags | Microsoft | 365 | education | learning | Excel | cell | column | row | data | constants | variables | calculation | function | recalculation | fill | fill handle | relative | relative references | absolute | absolute references | mixed | mixed references | XLOOKUP | VLOOKUP | HLOOKUP | LOOKUP | SPILL | table array | lookup vector | result vector | cpllumn index |
