**Vlookup with Match Formula**

VLOOKUP and MATCH functions gives you better control over how the column index number changes. This is often referred to as a dynamic formula. You will learn how this dynamic duo can help prevent errors and improve your VLOOKUP formulas.

**â€‹**

**The Dynamic Duo**

We are going to learn how the MATCH function can be used inside the VLOOKUP function. This helps protect the VLOOKUP from returning errors when changes are made to the workbook.

â€‹

**Problems with VLookup**

The VLOOKUP is a very useful function, but it doesn't respond to change very well. Have you ever noticed that if you add or delete columns in an area that the VLOOKUP refers to, the result can return an error or incorrect result?

â€‹

â€‹

**Refer to the attached sheet to learn the use of Vlookup with Match function**

**â€‹**