How to Change Dynamic Column Index in VLOOKUP Formula

How to Change Dynamic Column Index in VLOOKUP Formula

In this video we will learn about Vlookup Columns Function. Vlookup Columns Function is one of the most useful function in Excel and mostly used in offices, because it provides a dynamic results.

Vlookup Function only provides a value for one particular field but when we combine this with Columns Function then it provides a dynamic result with a single formula.

In the given example we have a data table and with Vlookup Columns Function we have to drag all the result with a single formula.

In this example when we apply Vlookup Formula, instead of putting column no. 2, 3, or so on, we need to put column no. in a different way, simply use Columns Function. Columns Function will be like “Columns ($B: B) +1”. “$B’ represent column “B” will be remain fix because we have put “$” sign before “B” so this column will be remain fix and second “B” will be move on according we will drag it.

We can see we have add “+1” in the columns function this is because when we drag formula towards right from left it will automatically add one to the column, like “B+1=C”, then “C+1=D”
and so on.

I hope you find this video useful.
So please like this video if you find it useful and subscribe the channel also.