MS Excel: VLookup Function (Basic to Advanced) | Lookup Function HD

Learn All the Excel Lookup Function under 90 Minutes Checkout Full Advanced Excel Course Library: https://bit.ly/30JD5is We Covered the following topics: 00:00 Introduction to VLOOKUP in Excel 01:34 Basics of VLOOKUP Formula in Excel 09:06 Apply TRUE instead of FALSE in VLOOKUP 15:34 What are the real-life application of VLOOKUP with TRUE 21:17 What is the difference between VLOOKUP and HLOOKUP in Excel 23:47 VLOOKUP Match Function in Excel 27:04 How Match can be used for slabs based data in Excel 30:37 What is 2D Lookup and how can it avoid complexly Nested IF statements 35:48 2D Lookup structure using VLOOKUP and Match in Excel 37:06 #1 Common mistake when writing 2D Lookup using VLOOKUP and Match 40:44 #2 Common mistake when writing 2D Lookup using VLOOKUP and Match 42:54 2D Lookup Project for Practice using VLOOKUP and Match 48:39 How to use 2D Lookup with HLOOKUP with Match 55:03 Basics of INDIRECT Formula in Excel 59:06 How to write dynamic formulas using the INDIRECT function in Excel 01:04:30 What is 3D Lookup 01:13:45 What is the Reverse Lookup in Excel 01:16:54 How to write a Reverse Lookup using INDEX with MATCH 01:24:20 Reverse Lookup Project for Practice - using INDEX with Match MS Excel: Vlookup, HLookup, Index, Match, Indirect & Many More. | Lookup Function #Lookupfunction #excelformula #excel Keep Yourself Updated. Follow Us Now!!! Like us on https://www.facebook.com/yodalearning​​​​ Tweet us at https://www.twitter.com/yodalearning​​​​ Follow our boards at https://in.pinterest.com/yodalearning