Vlookup with Columns Formula in Excel | Dynamic Vlookup | Automate Column Index Number in Vlookup

In this video you will learn how to make dynamic vlookup formula with the help of columns formula within vlookup formula. We can use columns formula in column index number to automate vlookup. Please watch video till the end. Thank You.

[@aryan8104]

Thanks for the video, it really solved my problem to manually change the column number

[@be-smart-at-office]

Glad it helped

[@stevebulls7744]

Interesting!! It seems so simple when you explain it yet, when I first saw the title, I had no idea how you would do it! Thanks!!

[@be-smart-at-office]

Thanks 🙏🙏

[@ryoyu994]

This video solved my curious question! Thank you !

[@ravikiran4738]

Thank you, helped me a lot with my work

[@be-smart-at-office]

Welcome 🙏

[@ProviderKnowledge]

it is great, sir

[@be-smart-at-office]

Thank you

[@jamalmuhammeda2538]

Very excellent....🎉🎉

[@be-smart-at-office]

Thank you 🙏

[@manissery1956]

Thanks a lot. Suppose we have to find max value among Jan to December and how to get name of that month and item using a formula. Hope you can suggest a solution.

[@nazarkamal8831]

Nice information thanks

[@be-smart-at-office]

Welcome 🙏

[@natarajangandhi2043]

Great Sir. God Bless you Sir

[@be-smart-at-office]

Thank you 🙏

[@ramkumarchourasia8030]

Very Nice❤

[@be-smart-at-office]

Thank you 🙏

[@learnit9m669]

Thanks for sharing

[@harsimransinghsethi9905]

Thank you so much

[@be-smart-at-office]

Welcome 🙏

[@manyika3125]

thanks boss

[@nabeelhoosen1669]

explained well thank you

[@be-smart-at-office]

Thank you 🙏

[@ritikkharwar3593]

❤

[@vickyrodriguez4779]

Hi Sir,
I couldn't use this columns function in my data because my column numbers are 2,3,11,12,13,14, finally 10 so how could I do that please suggest me or do 1 video for us

[@be-smart-at-office]

For this you can automate column index number by using match formula combination, there is one video tutorial in my channel, kindly go to videos section and find Vlookup+ Match video tutorial

[@josephdaquila2479]

I think index and match would work just as fine and the syntax would make more sense

[@be-smart-at-office]

Yes Index and match is the best👍

[@learnit9m669]

See u soon

[@shrinivasist]

सब खेल फ्रीज का है अगर आपका डॉलर साइन का कॉन्सेप्ट क्लियर नही है तो एक्सेल नही सीख सकते