How to automate VLOOKUP in Excel with VBA

Рет қаралды 22,874

Жыл бұрын

#VBA #VLOOKUP #ExcelFormula
Hello Friends,
In this video, we have explained how to use VLOOKUP function in Excel using VBA. We have explained two methods with step-by-step VBA code.
Download the practice file below link:
www.pk-anexcelexpert.com/how-...
Subscribe our new KZfaq Channel:
/ @neotechnavigators
Learn the more than 100 Excel formulas
www.pk-anexcelexpert.com/form...
Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
• Use of Symbols and Emo...
Learn Step by Step Pivot table:
www.pk-anexcelexpert.com/pivo...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
See our Power BI Dashboard videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Watch the Step-by-Step Tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/pks-...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

Пікірлер: 48

@setyoufree2726 Жыл бұрын

Excellent video. Straight to the point! Thanks

@PKAnExcelExpert Жыл бұрын

Most welcome 🙏

@rlpass.gaming9103 Жыл бұрын

Greeting from Cambodia. Thanks for the video.

@PKAnExcelExpert Жыл бұрын

Most welcome🙏

@temyraverdana6421 Жыл бұрын

A great tip. Thanks a lot

@PKAnExcelExpert Жыл бұрын

Most welcome🙏

@grijalvaescobedo158 Жыл бұрын

Excelente ING. Por compartir saludos 🇲🇽👍

@PKAnExcelExpert Жыл бұрын

Thanks🙏

@NeangBona Жыл бұрын

this file vba explanation is very clear PK I really like it so much thank you

@PKAnExcelExpert Жыл бұрын

You are most welcome

@nadermounir8228 Жыл бұрын

Super interesting Video 📹 Thank you PK

@PKAnExcelExpert Жыл бұрын

Glad you enjoyed it

@bharatparmar366 Жыл бұрын

Thank u so much for your guidance...

@PKAnExcelExpert Жыл бұрын

You're most welcome

@enemieskiller5537 Жыл бұрын

You always give good stuff to us Thanks bro❤

@PKAnExcelExpert Жыл бұрын

My pleasure

@evergreendays331 Жыл бұрын

Very Helpful sir,

@PKAnExcelExpert Жыл бұрын

Thanks a lot🙏

@jim27105 9 ай бұрын

Excellent tutorial and very informative

@PKAnExcelExpert 9 ай бұрын

Glad it was helpful!

@gayatricomputerjetpur5442 Жыл бұрын

Thanks Sir ji 🙏

@PKAnExcelExpert Жыл бұрын

Welcome

@alializadeh8195 Жыл бұрын

Thanks

@PKAnExcelExpert Жыл бұрын

Welcome

@susenDeshmukh-zt7so Жыл бұрын

👍👍

@PKAnExcelExpert Жыл бұрын

Thanks🙏

@anbaabdellah8022 Жыл бұрын

top

@PKAnExcelExpert Жыл бұрын

Thanks🙏

@shashipothu264 6 ай бұрын

Can you explain why you have you used i column in vba or i means any example in vba

@alteavanloggerenberg2464 9 ай бұрын

Hi, how can I use this script with a loop function, to search through multiple and specific sheets. If it didn't find value in sheet 1 then it would continue through the sheets until it does find a match?

@thevoiceoftruth5116 Жыл бұрын

Is it useful for vlookup for cels have two values

@PKAnExcelExpert Жыл бұрын

It will work as same as manual VLOOKUP works

@TriLok84 10 ай бұрын

I have consolidated multiple woksheets from different source to a single woksheet and using VBA code to perform vlookup and observed from the joining place wherever new data started from that row vlookup is not working. But while doing manual vlookup it's working.

@ameeraliadcoopsabudhabi8923 2 ай бұрын

Can i get it copy of vba

@alializadeh8195 Жыл бұрын

When I try to download practice file you ask me to disable Add Blocker. Please correct this problem so I can download if may, either forget me ... because the security for my pc is more impoertant than download a practice excel file. Thank you again.

@currentbulb9955 10 ай бұрын

what if the table range is from another file?

@shibapaningrahi8749 Жыл бұрын

How to automate this vba so that it works without manually running it frequently

@PKAnExcelExpert Жыл бұрын

You can assign it on a button Or you can schedule it to run

@shibapaningrahi8749 Жыл бұрын

@@PKAnExcelExpert sir I want do it fully automatic just like automatic filter vba code in which as soon as we enter data it got filter through vba without pressing any button

@phacialoveskakashi2119 Жыл бұрын

You might be able to automate it by having it run in the sheet on opening, but that won't help much if you adjust the data on the sheet. Honestly, i am not sure who easy that would be to code in VBA. It's not difficult in visual basic studio to do that.