Automate VLOOKUP in Excel using VBA Programming | Vivekananda Sinha | Video 137

[@iamsmtutube]

Excellent🎉

[@rajeshshinde2714]

Superb sir, this is exactly I was looking for for👍

[@Futureinhands]

Great 👍

[@girishsawant8263]

Wow...!! Superb one.
Very useful video.
Thank you very much Sir !🙏🙏🙏

[@Futureinhands]

So nice of you. Thank you so much. Keep learning.

[@omrankhan1377]

Thanks a lot, simple syntax provided and your way of explanation is superb.

[@Futureinhands]

Thank you so much. Stay connected.

[@anmoljangid551]

Thankyou sir it's a very helpfull video

[@dileepmathulkar6516]

Basically, I am afraid of VBA but you have made it quite simple.
Thanks. 👌

[@Futureinhands]

Thank you so much. Keep learning.

[@pramodbhatt1316]

Thanks a lot Sir I Love your teaching way trying to find Vlookup VBA recording from last 2 hour but finally got this. Thanks again Sir.

[@Futureinhands]

You are most welcome.

[@JUSTIMAGINE_Hari]

Awesome 👌

[@sukrutbhujbal4457]

The best video on vlookup

[@breakingbad582]

Master, amazing 😊👏👏👏

[@Futureinhands]

Thank you! 😃

[@sunilchoudhary859]

Aapka padhane ka andaz zabardast hain

[@Futureinhands]

Thank you so much. Keep learning.

[@avinashmajhi2510]

Simply awesome 🌟

[@sunilchoudhary859]

Lovely Sir

[@Futureinhands]

Thanks.

[@navtej86amb]

Hi, I wanted to change the column no for I column, can you please tell how?

[@Futureinhands]

You can count the column from the first column and use that number.

[@navtej86amb]

@@Futureinhands wanted to change the I column.
Why it’s not A column?

[@vishnukumarpatel3694]

Thanks

[@debanandasahoo6]

Sir, it working in a small data......but i run into 30000 or more data it hang and i forcefully close the excel.

[@Futureinhands]

Yes for this we have to use another very easy technique. We will update the formula in first cell and then copy paste the formula in the entire range. The complete task can be automated using VBA.

[@momi3652]

Sir g how to do it with multiple sheets.

[@Futureinhands]

Loop chala padega sheets me bhi

[@pramodbhatt1316]

Sir, Can u Pl make a recording of Vlookup again where data in different workbooks.

[@Futureinhands]

Sure

[@pramodbhatt1316]

@@Futureinhands Thanks Sir. Pl reply once u upload the same in you tube

[@hemanthsivakumar]

Sir please make a video for the same but when data is in different workbooks.

[@peterjohn009]

hai, will Vlookup work in table range??

[@Futureinhands]

Yes

[@kidsworld7459]

Its fantastic but sir how to lookup value from multiple sheets to one sheet by vba. Pls help me to solv this problem.

[@Futureinhands]

You can use the below concept in VBA:
ruclips.net/video/g3whBLtT_xw/видео.html

[@suhasm2009]

How to give reference If data sheet is in other file.

[@Futureinhands]

You have to create a variable for the file also. I have created multiple videos on this

[@vishnukumarpatel3694]

Indirect vlookup match function video

[@vishnukumarpatel3694]

In vba indirect vlookup match function video pl

[@Futureinhands]

Sure

[@sunilchoudhary859]

Vba ka pura loop serees upload kijiye

[@Futureinhands]

Bilkul karoonga one after another.

[@iClone316]

Clickbait thumbnail. Reporting you.

[@Futureinhands]

But i have taken this from Canva that contains all professional thumbnails. And its properly pointing the title of the Video. How it could be clickbait. Please help me to understand. Thank you.