In this video detailed explanation of how to use the VLOOKUP and MATCH functions to lookup data dynamically or how the column index number changes automatically. This is often referred to as a dynamic formula. You will learn how this help prevent errors and improve your VLOOKUP formulas dynamic. We are going to learn how to use MATCH function inside the VLOOKUP function.br br Please watch this video till the end to know more.