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

[@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!!

[@smart-office12]

Thanks 🙏🙏

[@aryan8104]

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

[@smart-office12]

Glad it helped

[@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.

[@ramkumarchourasia8030]

Very Nice❤

[@smart-office12]

Thank you 🙏

[@jamalmuhammeda2538]

Very excellent....🎉🎉

[@smart-office12]

Thank you 🙏

[@nazarkamal8831]

Nice information thanks

[@smart-office12]

Welcome 🙏

[@ravikiran4738]

Thank you, helped me a lot with my work

[@smart-office12]

Welcome 🙏

[@ProviderKnowledge]

it is great, sir

[@smart-office12]

Thank you

[@ryoyu994]

This video solved my curious question! Thank you !

[@natarajangandhi2043]

Great Sir. God Bless you Sir

[@smart-office12]

Thank you 🙏

[@learnit9m669]

Thanks for sharing

[@nabeelhoosen1669]

explained well thank you

[@smart-office12]

Thank you 🙏

[@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

[@smart-office12]

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

[@harsimransinghsethi9905]

Thank you so much

[@smart-office12]

Welcome 🙏

[@manyika3125]

thanks boss

[@josephdaquila2479]

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

[@smart-office12]

Yes Index and match is the best👍

[@learnit9m669]

See u soon

[@ritikkharwar3593]

❤

[@shrinivasist]

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