Learn Excel - Video 237 - VBA Vlookup Function with loops

In this video we are learning how to use Vlookup in VBA and combine it with loop and error handlers.
Please see the below series information along-with links and join me in these world -class designed live classroom sessions. Bet. you will not be disappointed.
POWERPIVOT WITH DAX - PART1/2 (New Launched)
www.udemy.com/...
POWERPIVOT WITH DAX - PART2/2 (Just Launched)
www.udemy.com/...
LEARN DAX IN POWERBI DESKTOP - Part 1/2
www.udemy.com/...
LEARN DAX IN POWERBI DESKTOP - Part 2/2
www.udemy.com/...
POWER BI -BASIC TO ADVANCE PART 1 / 2 (New Course)
www.udemy.com/...
POWER BI -BASIC TO ADVANCE PART 2 / 2 (New Course)
www.udemy.com/...
Excel Power Query
www.udemy.com/...
Excel Power Query M Code Programming - Part 1
www.udemy.com/...
Excel Power Query M Code Programming - Part 2
www.udemy.com/...
Excel Power Query M Code Programming - Part 3
www.udemy.com/...
• [Excel VBA Series Links are mentioned below - basic to super advance]
Excel VBA Introduction Series 1
www.udemy.com/...
Excel VBA Loops and IF functions Sereis 2
www.udemy.com/...
Excel VBA Collection Loops and Workbook /Sheets handling Series 3
www.udemy.com/...
Excel VBA Super Strong Arrays Series 4
www.udemy.com/...
Excel VBA Functions Series 5
www.udemy.com/...
Excel VBA File and Folder Handling Series 6
www.udemy.com/...
Excel VBA In depth UserForm Series 7
www.udemy.com/...
Excel VBA error handler and Message box /input Box Series 8
www.udemy.com/...
Excel VBA Amazing and Phenomenal Events Series 9
www.udemy.com/...
Excel VBA Awesome Pivots - Series 10
www.udemy.com/...
Excel VBA Charts Series 11
www.udemy.com/...
Excel VBA Connecting Outlook Series 12
www.udemy.com/...
Excel VBA Connecting Powerpoint Series 13
www.udemy.com/...
Excel VBA Connecting MS Access - Series 14
www.udemy.com/...
Excel & Access VBA Dashboard and Projects - Series 15
www.udemy.com/...
Web Scraping Using Excel VBA - Series 16
www.udemy.com/...
VBA Web Selenium Web Scraping Part 1/2
www.udemy.com/...
VBA Web Selenium Web Scraping Part 2/2
www.udemy.com/...
• [MS Access VBA Series]
Access VBA Introduction Series 1
www.udemy.com/...
Access VBA Arrays and Functions Series 2
www.udemy.com/...
Access Userform and SQL Series 3
www.udemy.com/...
Access VBA File Handling and Error Handlers Series4
www.udemy.com/...
Connection Set-Up AccessVBA & Security (ADODB &DAO Series-5)
www.udemy.com/...
Connect XL & Outlook Access VBA & Collection Loops Series 7
www.udemy.com/...

[@EventPersona]

This what i wanted..!! I have been searching for this for 3 day. But now today i got the correct and easy way to do this. Thanx bro..!!👍👍

[@AjayKumarparmar]

Good good... Keep it up

[@sandyab2895]

wow - you were so clear and even with zero knowledge we can learn

[@AjayKumarparmar]

Thank you

[@pawanhandala]

Wow that's fantastic.i tried same yesterday but same errors i was faced..i watched another video s regarding that.but simply u are the best..as it is very very good.

[@anushreesharma3754]

Sir sir sir.. you are great... Your teaching style is very friendly and simple.. Thank you 😊 sir

[@AjayKumarparmar]

Keep watching

[@kumarnarayanan80]

Very simple and understandabe way as you mentioned, great job thanks

[@saurabh123kush2]

Thanks Ajay it will more helpful if you make video with iferror + vlookup formula by vba code.

[@SaiKiran-gr8gr]

No words for your teaching skills....You are the best of all I seen till now 🙏

[@AjayKumarparmar]

Thank you for your great words

[@MohAboAbdo]

Thank you very much for this great video and for this valuable informations and for this simple and clear and wonderful method.

[@Niraliiii]

Amazing code ... Helped a lot ... Explained beautifully

[@deepakvaishy7754]

Greater than the greatest. Grand Salute to you Sir!!

[@hazemali382]

More than great

[@jitendraparekh3752]

very excellent style of teaching. Every concept of VBA is very clear through your Videos. In every video we learn some new concepts of VBA which i never learn before.

[@AjayKumarparmar]

Welcome to the channel..

[@smrenterprises6817]

U r A perfect teacher . I wish u A suessful and bright future.

[@chanchaldas6229]

Thanx sir. Nice video.

[@aainahutera1676]

Very very useful video nicely explained

[@rajgautam5282]

Amazing, Clear, Informative. You are such good tutor. Thanks a lot to you.

[@VickyT2843]

Thanks Ajay Sir, it's an great Video ever on Vlookup

[@1taki]

it helps me in my macro. Thanks a lot!

[@sintulaha8659]

awesome

[@amitshikhare1408]

Very informative and helful.. The steps are explained very well

[@nhungqnk]

Thanks a lot for this! Been picking my hair the last 2 hours on Stackoverflow to find the solution but nothing comes close to this. Very simple code and great explanation :)

[@AjayKumarparmar]

Thank you. Very happy to know you got it

[@praveenav6690]

Thank you so much . Such a wonderful video

[@followthetruth3283]

Amazing bro.. Amazing.... really I salute to you.... you are my best teacher of excel in world.....

[@saideswaraokota5167]

Thank you Ajay this is very usefully to me

[@abdulrasheedpalara597]

Very nice and really helpful 😊 your explanation is awesome

[@AjayKumarparmar]

Thank you

[@rakeshkumarmadella7955]

I am really, really enjoying it & it was a grt tip to change variable I from to IThank you so much... Please don't ever stop ever uploading videos what may come.

[@AjayKumarparmar]

As long as viewers are watching videos and ads...they giving me great support... thank you

[@jeganm5502]

Really great man... After watching so many video, u clarified my doubts 👏

[@AmarjitSingh-wn7ct]

Hi Ajay, I have seen many videos on vlookup. They are so complex to understand but your code is so simple to understand. It is nice & your way of defining is superb. Can you please define how I can select dynamic range of data in above code. In my case I import my sales data every day and the range is dynamic. Hope you clarify soon. Thanks

[@AjayKumarparmar]

See rest vkookp videos under Playlist excel vba functions.

[@RightToSalute]

2 साल पहले का वीडियो 2 साल बाद देख रहा हूं दुर्भाग्य है मेरा ।

[@AjayKumarparmar]

My dear student.. Never say so. Your time has come. Now shine... Ab dekh Lau sabhi videos. Life mein learning jab bhi start ho tabhi badia

[@RightToSalute]

@@AjayKumarparmar आपके शीघ्र उत्तर के लिए धन्यवाद । क्योंकि मैं आपका विद्यार्थी हूँ तो मन की झिज्ञासा को आपके समक्ष रखना चाहता हूं । मैंने एक userform बनाया है जिसमे Sheet1 के A:A सेल में मैटेरियल्स लिस्टेड हैं । इसे मैं फ़िल्टर करना चाहता हूं । मैं चाहता कि combobox1 में जब मैं मटेरियल सर्च करू तो , dropdown में मुझे suggestion दिखाई दे । Ex- जब में combobox में ind लिखूं तो dropdown में india और west indies दोनों show होना चाहिए । और जब कोई दूसरा word टाइप करूं तो पहला null होना चाहिए और searchbox में टाइप word के हिसाब से दूसरे सिमिलर डेटा दिखाना चाहिए । तो गुरुजी जल्दी बनाइये ऐसा कुछ लॉजिकल userfrom

[@sandipmakwana6462]

Super vedio and super trick for taking range -3 👌

[@AjayKumarparmar]

Happy you liked it

[@jawedsheikh7256]

Its very nice but if i have to apply more vlookup in next column for any other value in that case what should i do?

[@PankajNegi007]

Great Bro

[@sangramjsw]

Awesome Sir.

[@meragaonconnection7382]

Awesome....

[@CHINGUENASUMADREPUES]

Thanks man, you're the best

[@juanangelmartinezgarcia1900]

thank you so much, it was amazing regards from México

[@AjayKumarparmar]

love to mexico from india...

[@redhead5222]

Great video, thanks.

[@AjayKumarparmar]

You are welcome!

[@mohammadaslam5218]

Wish you all the best ...

[@mohammadaslam5218]

Amazing brother,

[@jaat__---]

Awesome👍

[@AjayKumarparmar]

Thanks 🤗

[@udaykiran52]

Hi Ajay, As explained the error function applied in loop concept, but not working. Can you please explain. And also We are decrypting 100's of Excel files using vba as common password as "1". Some times others giving another password, then how can we find out that file name without debugging the procees? Please help in this.

[@upgradetechnicalskills3392]

Hi Ajay, Good afternoon Hope you are doing well!! My query is in excel sheet if will apply the Vlookup function as soon as we enter the lookup value formula will bring the value from table. for VBA I need to click the command botton then only the value will show. Is there any feasibility to do as we are getting with formula

[@keharsingh2396]

Oswm sir

[@VickyT2843]

Great video Sir.. But one dought i have in my mind. How I can use event for automatic changes in values. If I don't want button press option.

[@jagadeeshmadugula5651]

very nice explanation ajay

[@preetishrivastava183]

Superb

[@ORANGEPICTURESOFFICIAL]

Sir... Please do a vlookup for filtered data video........

[@glitterworldcreation]

Ya this one is the best

[@gadeamol88]

Osm..

[@shafiulamin4128]

Great video brother. Looking forward to watch the other videos. Thanks a lot.

[@AjayKumarparmar]

Thanks shafiul. Please make other people aware of the channel. You call me brother so brother need more people come to channel and learn.rise and shine.

[@shafiulamin4128]

HI Ajay, Thanks for replying. I will definitely let my colleagues and friends know about your wonderful channel. Keep up the good work. Thanks again.

[@amitkasare9156]

Hi sir......one query hai meri....mere pass ek data means master file hai usme name, mobile no, city, order, pincode,status - Dispatch & Pending hai. muje master file me se Dispatch & Pending file new sheet me Lana hai.dispatch & pending data separate mean new sheet create honi chahiye. Pending & dispatch 2 new sheet create hone ke baad jab measter file me new data add Karu tab wo data status ke jariye pending & dispatch sheet me add hona chahiye automatically....ye query formula or VBA coding ke kaise solve hogi...plz tell me formula or VBA code.

[@rajeevsrivastava4963]

awesome it very good easy way to use through VBA.

[@AjayKumarparmar]

thanks Rajeev..

[@vijaysahal4556]

very useful nd very good vba vlookup with for loop but in this example only use one column but if we have to use more then use column then what we will do sir but how cn we use invba vlookup with match for column plz if possible then plz share with me this topic

[@kumarnarayanan80]

One question, if we do multiple filter in column of look-up value, and apply the same vba code will it bring only the selection of filter value results?

[@767692]

Thank youuuuu.

[@athulabraham3370]

Thank you so much . This video is really helpful😊

[@AjayKumarparmar]

Thanks for the feedback

[@omprakashrs]

Nice video. Just have a question. When I have multiple columns as my range for vlookup, how do I provide it. For e.g. if my range is from A3 to BX and the number of rows are huge, say 50000 rows, can I refer the range in vlookup something as follows, Vlookup (Tax-id, Range ("A3:BX" &rowcount), 24,FALSE). Here, the rowcount is the total number of rows available in my table that needs to be referred. I. getting an error application defined or object defined error. Can you please guide. I am relatively new to Excel VBA/Macros. Thanks.

[@greenivarughese4332]

I have a doubt If I want the value as yes or no.. how can I modify the code?

[@faizanfaizy9709]

great work Sir,, thumbs up from Pakistan, where do we get this workbook for practice?

[@zohaibazam7300]

I wan to ask what if my data base row are variable Can i use the below code H = Application.WorksheetFunction.CountA(Worksheets("SQL Results").Range("$Y:$Y")) Range("W" & i + 1).Value = WorksheetFunction.Vlookup(Range("B" & i + 1).Value, Range("Y" & C), 1, False) Do i need to put $ signs to freeze the table

[@DSureshKumar]

Sir hum userform ko fully dynamic kaise create kare excel mein. Pls pls reply...

[@mypinkladydecorations9020]

HI I have a question would you be able to help me find an error message in my vlookup macro from another worksheet that it's not picking up the formula.

[@manjeetkumar52]

I am using vlookup function on A sheet having 50000 rows nd 46 column with an unique I'd.and correspondence workbook have more header with 200000 rows. Vlookup just looking unique I'd and pasting the data accordingly. My code is going undefined stage. How much time it should be take to finish. I have used your code with do while loop. It's working nice with F8.

[@banwarifageriaexcelclasses1447]

very knowlegeable video

[@AjayKumarparmar]

Great...

[@adirohila]

Sir Aapke video bahut achhe h. Mein chahta hu ki aapka channel khub badhe. Lekin India me 5% log English achhe se jante aur samjhate h. Isliye in sabhi topic (according to your video) pr hindi me video banaye. Aapke subscribers bhi badhenge aur aapka channel bhi khub grow karega. Apko india,pakistan,nepal, bangladesh jese desho se bhi khub viewers & Subscribers milenge.Aapne dekha bhi hoga technical guruji, technical sharmaji jese channel hindi me hi h aur khub grow kr rhe h.

[@AjayKumarparmar]

Bilkul... Sahi baat hai. Shuru karte hai hindi mein. Jai ho

[@manjeetkumar52]

Hi Ajay, I am learning by Your videos. Its Amazing. Can you please give a link for Vlookup Function for Multiple columns selection at a time from Different Workbook to current workbook based on Ids..

[@AjayKumarparmar]

Check excel vba function hindi Playlist

[@gerardvaneggermond9967]

Hello, I have a problem with an Excel worksheet (there are 3 that look the same) now it is that I want to look up, (it is quite complicated,) I first want to indicate the sheet where I want to search then the ID NAME ( which is at the top), then in the columns associated with the 1st ID, each ID has a name of the person, (20 people), each person has 5 columns, 1) the ID, 2) the name of a person who changed, 3, 4, 5 are data that I want to retrieve, now I don't know if I have to use a form or just make a separate timetable for each worksheet, can you help me? Feel free to ask if you have any questions.

[@AjayKumarparmar]

for any project related thing you can visit my website www.excelvbalover.com or email me at [e-mail]

[@mishraamukesh]

How to create a daynamic dependent drop-down list based on 3 combo boxes in VBA without using any name range or Excel sheet entry.

[@balareddy7563]

Thank you this was very helpful

[@AjayKumarparmar]

Thanks Bala . Let more people come on Channel and learn. Please assist.

[@surender665]

Sir, plz make video in hindi for how to merge data in master workbook from any folder (other workbooks)

[@vishalsharma7058]

Hi Sir, I have to two workbooks wb1 and wb2 now I want to copy the data from sheet1 of wb1 by searching the particular column by its "name" and then pasting in sheet1 of wb2 by again finding that particular column by its "name" then pasting the wb1 sheet1 data in sheet1 of wb2. I have multiple columns in the sheet1 of wb1. I want to loop through all columns that I want in sheet1 of wb1 and repeat above task for them. And While finding column it should find by column "name" and not by column number, since my sheets column position keeps changing. Please help on this....!!

[@suribhandari1985]

Hi Sir, This video is awesome, but why don't you change the nameing convention of the video because it has vlookup, loops two type of error handling. This is really mind bowling video.

[@AjayKumarparmar]

Thanks again for liking the work. Title Says it's awesome so I meant it when I said that...:)

[@rakeshkumarmadella7955]

yes really wonderful video

[@AjayKumarparmar]

Thanks a lot again...

[@sansaraaerdenedalai4594]

The lesson is amazing but with 0.75X speed. :)

[@pratishpratish5055]

I have a question and sample Excel file. how do I reach out to you? somehow I will try to explain my doubt. How to copy the pivot table to a different sheet (I can do this) and use the match function with a few conditions that are in the different sheets. This should be dynamic

[@AjayKumarparmar]

You can email me for this project. [e-mail] or what's app 9810375599

[@jim3805]

Another way of doing this is would be using IFERROR with VLOOKUP... and creating a dynamic formula range macro

[@AjayKumarparmar]

Yes that's correct but it cannot be applied in complex scenario. If you have fifty files and u want to look up each file and they have data in different cells then u have to use loops and vlookup in this way and not recording...

[@azharkarol7314]

Sir how to use this formula in multiple columns

[@mohit8460]

Hello sir, similarly what if there are multiple same look-up value and we need to get next values then how to modify this logic? Please let me know it's bit important for me to know

[@AjayKumarparmar]

Better create VBA udf

[@rajmohanattoor2476]

perfect

[@smaranikapradhan2769]

Hi Ajay, I wanted to know how can I use the same Vlookup formula in 2 different workbooks using Macros

[@AjayKumarparmar]

Use inbuilt vlookup VBA function with collection loops

[@jessipinkman7659]

Sir, Kudos to you! Amazing ! What if we want to leave the cell blank instead of not found , so we can = "" ?

[@AjayKumarparmar]

Yes.. You can..

[@redhaakhund1271]

👍👍👍👍👍

[@darkh6940]

What will be the add-on in code, if values should copied with cell format?

[@AjayKumarparmar]

You can check cell Formatting using cell properties and implement same

[@saravanannaidu1643]

Good Explanation Ajay Sir, I have one query sir, I used the same VBA script for vlookup using loop and i also got the data however some data not reflected even if the vlookup data was available in the sheets

[@AjayKumarparmar]

Playlist is Excel vba functions hindi. Go here and see more vlookup videos in hindi.. You will learn more and will be able to sort out. If you using on error resume next then vba will not give error so remove the line and debug again

[@pankajvishwakarma3554]

Satish Sir form lear More channel tell us to watch your video. It's Great learning from your end. My Question To you : Do we able to create some function which helps us to reverse vlookup instead of using an index match function. As I see in many Interview the interviewer as the question can you apply reverse vlookup. So, I can do the thing with Index match function But, I want to show them that, I can also do with the help of VBA developing our own Ulta Vlookup. To surprise them. Also Form Mine side i am making a project, with the help of that we can increase a Number of the subscribers Instantly.

[@AjayKumarparmar]

You can create your own vba function.. Simple

[@sjway9686]

Sir thanks for such a nice explanation, i want to do something with other workbook, like i have three workbook with some data in all workbook with one unique id column which is common in all three workbook, so i want to pull two columns from one workbook and one column from 2nd workbook to the third workbook with that unique common column values using VBA, can you help me getting. It will be helpful for me. Thanks!!

[@spencerhinds1267]

Great video!

[@spencerhinds1267]

Can you explain how someone could lookup data in columns F, G, and H?

[@spencerhinds1267]

For example, you extracted STUDENTS ENROLLED data in to column F. How could someone then extract YEAR data in to column G? Hope this makes sense.

[@AjayKumarparmar]

Thanks for appreciation..

[@AjayKumarparmar]

You just need to run the loop on those cells. Need to change the range and that's it. I would suggest you to go and watch basic intermediate and then advance vlookup videos under Playlist.. Excel vlookup and match... Let me know if you need any help

[@nullhas]

Sir, Could you please make a video of mailmerge using vba? I know how to merge from excel to word. But i need the result like each word documents should be saved in seperate pdf files. Please help us.

[@archanaaa2514]

Sir, I am a beginner to vba code. For getting a job how much should I knw about vba as a fresher?

[@AjayKumarparmar]

you can join my course. Check my website www.excelvbalover.com

[@ordinary786]

hI AJAY , am unbale to find ur series since begining , i.mean.. how to use vlookup in VBA..biginner to advance

[@hiteshsehgal9666]

If I delete the table from which the data I want to add after applying the formula in the main table (result table) does the value in main table will be same or changes or it will show error

[@AjayKumarparmar]

It works same way as in excel front end. Now depending on the situation we can modify the things. When macro runs it overwrite previous things. If you want to ignore there are several ways... First thing... You should understand that anything can be done in vba.. How one want...

[@SannareddyHarshavardhan547]

Thank You !!!

[@AjayKumarparmar]

You're welcome sir..

[@MandeepSingh-dz3eh]

Hi Ajay, can you please help me... How can I use Networkdays function in MS-Access

[@AjayKumarparmar]

Same as excel

[@sandeepkumar-cx4or]

Superb video keep it up

[@AjayKumarparmar]

Cheers man.

[@rakeshkumarmadella7955]

Sir.. If have get year also next colume.how do I go it.. Please

[@rahulambast2056]

sir I want to make vlookup via arrays 10 to 12 columns can be possible that we can use only one loop and data should be update in all columns , so plz suggest how can I get all data via loop

[@AjayKumarparmar]

check vlookup series - playlist name is excel vba functions hindi

[@DeepakKumar-pc6bu]

Sir, userform me vlookup kaise find karenge, agar hame string k sath variable v find krna ho to

[@AjayKumarparmar]

Just use correct data type

[@DeepakKumar-pc6bu]

@@AjayKumarparmar I don't understand what you say, actually I just find out the numbers and alphabets too, in a same criteria. Actually I used "clng" for numbers but I don't know how to find the alphabets using vlookup.

[@DeepakKumar-pc6bu]

@@AjayKumarparmar which data type sir, plz help

[@Moba-game-]

Hay sir, if more than one that 1 range I want to look for please give an example, examp : I want yo get year too

[@AjayKumarparmar]

Check more vlookup video on same

[@unofficialwork7316]

how can use vlookup with mulitple workbook if you have already make videos plz share link......thanks

[@AjayKumarparmar]

yesterday i uploaded a video...check that...playlist name is excel vba functions

[@manojsogam7763]

Hi Ajay Can you share the VBA code for median mode and SD for multiple criteria ...... It's criteria will be same like sumifs and count ifs function.....

[@AjayKumarparmar]

U can use vba functions

[@manojsogam7763]

@@AjayKumarparmar pls help to get the solution...if you share the video many user can know about how to used mean mode , median and SD on multiple criteria ........

[@AjayKumarparmar]

@@manojsogam7763 you can learn functions and loops. Nothing else is required. Base needs to be strong

[@manojsogam7763]

Thank you for your prompt response