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.
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.
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.
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.
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 :)
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
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
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
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.
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
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?
@@AjayKumarparmar आपके शीघ्र उत्तर के लिए धन्यवाद । क्योंकि मैं आपका विद्यार्थी हूँ तो मन की झिज्ञासा को आपके समक्ष रखना चाहता हूं । मैंने एक userform बनाया है जिसमे Sheet1 के A:A सेल में मैटेरियल्स लिस्टेड हैं । इसे मैं फ़िल्टर करना चाहता हूं । मैं चाहता कि combobox1 में जब मैं मटेरियल सर्च करू तो , dropdown में मुझे suggestion दिखाई दे । Ex- जब में combobox में ind लिखूं तो dropdown में india और west indies दोनों show होना चाहिए । और जब कोई दूसरा word टाइप करूं तो पहला null होना चाहिए और searchbox में टाइप word के हिसाब से दूसरे सिमिलर डेटा दिखाना चाहिए । तो गुरुजी जल्दी बनाइये ऐसा कुछ लॉजिकल userfrom
@@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.
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.
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
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.
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 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 ........
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.
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.
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
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
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
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
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...
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
Please visit www.excelvbalover.com for my online training content. Or on you tube channel... Start with these Playlist... Excel vba introdcution.. Excel vba loop, Excel Vba collection Loops, Excel vba workbook handling, Excel Vba file handling, Excel Vba function, Excel Vba arrays, Excel Vba connect outlook with Excel, Excel Vba Access, Excel Vba powerpoint with Excel...
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
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.
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..
Hi Jorge... In that case you need to mix vlookup with Loops. You can use for next loop. I have basic and Advance videos on Loops, if you need to get more understanding. Watch Playlist.. Excel vba Loops... Start first with basics.however I will upload the video on same as well... Good luck... Keep watching..
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....!!
wow - you were so clear and even with zero knowledge we can learn
Thank you
Sir sir sir.. you are great...
Your teaching style is very friendly and simple..
Thank you 😊 sir
Keep watching
Very simple and understandabe way as you mentioned, great job thanks
Amazing code ... Helped a lot ... Explained beautifully
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..!!👍👍
Good good... Keep it up
No words for your teaching skills....You are the best of all I seen till now 🙏
Thank you for your great words
Greater than the greatest.
Grand Salute to you Sir!!
More than great
Thank you very much for this great video and for this valuable informations and for this simple and clear and wonderful method.
Very very useful video nicely explained
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.
Awesome Sir.
Thanx sir.
Nice video.
it helps me in my macro. Thanks a lot!
Thank you so much . Such a wonderful video
Very informative and helful.. The steps are explained very well
Thanks man, you're the best
Awesome👍
Thanks 🤗
Thanks Ajay Sir,
it's an great Video ever on Vlookup
Thanks Ajay it will more helpful if you make video with iferror + vlookup formula by vba code.
Very nice and really helpful 😊 your explanation is awesome
Thank you
Awesome....
Wish you all the best ...
Great Bro
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.
Welcome to the channel..
Super vedio and super trick for taking range -3 👌
Happy you liked it
Great video, thanks.
You are welcome!
Thank you Ajay this is very usefully to me
awesome
Amazing brother,
Amazing, Clear, Informative.
You are such good tutor. Thanks a lot to you.
thank you so much, it was amazing regards from México
love to mexico from india...
Superb
Great video brother. Looking forward to watch the other videos. Thanks a lot.
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.
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.
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.
As long as viewers are watching videos and ads...they giving me great support... thank you
awesome it very good easy way to use through VBA.
thanks Rajeev..
Amazing bro.. Amazing.... really I salute to you.... you are my best teacher of excel in world.....
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?
very nice explanation ajay
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 :)
Thank you. Very happy to know you got it
U r A perfect teacher . I wish u A suessful and bright future.
Great video!
Can you explain how someone could lookup data in columns F, G, and H?
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.
Thanks for appreciation..
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
very knowlegeable video
Great...
yes really wonderful video
Thanks a lot again...
Ya this one is the best
Thank you so much . This video is really helpful😊
Thanks for the feedback
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
See rest vkookp videos under Playlist excel vba functions.
Superb video keep it up
Cheers man.
Oswm sir
Hi Ajay,
I wanted to know how can I use the same Vlookup formula in 2 different workbooks using Macros
Use inbuilt vlookup VBA function with collection loops
Thank youuuuu.
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
You can email me for this project. Ajayk3802@gmail.com or what's app 9810375599
how can use vlookup with mulitple workbook if you have already make videos plz share link......thanks
yesterday i uploaded a video...check that...playlist name is excel vba functions
Osm..
Sir how to use this formula in multiple columns
I have a doubt
If I want the value as yes or no.. how can I modify the code?
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.
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
Thank you this was very helpful
Thanks Bala
. Let more people come on Channel and learn. Please assist.
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?
2 साल पहले का वीडियो 2 साल बाद देख रहा हूं दुर्भाग्य है मेरा ।
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
@@AjayKumarparmar आपके शीघ्र उत्तर के लिए धन्यवाद । क्योंकि मैं आपका विद्यार्थी हूँ तो मन की झिज्ञासा को आपके समक्ष रखना चाहता हूं । मैंने एक userform बनाया है जिसमे Sheet1 के A:A सेल में मैटेरियल्स लिस्टेड हैं । इसे मैं फ़िल्टर करना चाहता हूं । मैं चाहता कि combobox1 में जब मैं
मटेरियल सर्च करू तो , dropdown में मुझे suggestion दिखाई दे । Ex- जब में combobox में ind लिखूं तो dropdown में india और west indies दोनों show होना चाहिए । और जब कोई दूसरा word टाइप करूं तो पहला null होना चाहिए और searchbox में टाइप word के हिसाब से दूसरे सिमिलर डेटा दिखाना चाहिए । तो गुरुजी जल्दी बनाइये ऐसा कुछ लॉजिकल userfrom
Sir, userform me vlookup kaise find karenge, agar hame string k sath variable v find krna ho to
Just use correct data type
@@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.
@@AjayKumarparmar which data type sir, plz help
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.
Really great man... After watching so many video, u clarified my doubts 👏
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.
Sir hum userform ko fully dynamic kaise create kare excel mein. Pls pls reply...
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
Better create VBA udf
Thank You !!!
You're welcome sir..
Sir... Please do a vlookup for filtered data video........
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.
for any project related thing you can visit my website www.excelvbalover.com or email me at ajayk3802@gmail.com
Hi Can this be done using xlookup?
Yeah
@@AjayKumarparmar please drop me the code thank you in advance
Wt if i want to pull data from other excel?. Wt will be change in code
Define workbook using set keyword.. and same for sheet and ranges
I teach 10 subjects. Please whats app or call or visit my website www.excelvbalover.com
Hi Ajay, can you please help me... How can I use Networkdays function in MS-Access
Same as excel
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.....
U can use vba functions
@@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 ........
@@manojsogam7763 you can learn functions and loops. Nothing else is required. Base needs to be strong
Thank you for your prompt response
great work Sir,, thumbs up from Pakistan,
where do we get this workbook for practice?
Really Nice Vedio
Thank you for taking out time and giving positive feedback
+Ajay Kumar sir how will I get all video from beginning
Can we add this code while saving
Use save event
perfect
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.
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.
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
check vlookup series - playlist name is excel vba functions hindi
Sir, I am a beginner to vba code. For getting a job how much should I knw about vba as a fresher?
you can join my course. Check my website www.excelvbalover.com
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
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
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
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...
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
Hi Ajay Sir,
what is best ways to Learning VBA concepts step I idea please share you view ..
Please visit www.excelvbalover.com for my online training content. Or on you tube channel... Start with these Playlist... Excel vba introdcution.. Excel vba loop, Excel Vba collection Loops, Excel vba workbook handling, Excel Vba file handling, Excel Vba function, Excel Vba arrays, Excel Vba connect outlook with Excel, Excel Vba Access, Excel Vba powerpoint with Excel...
Sir.. If have get year also next colume.how do I go it.. Please
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
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.
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..
Check excel vba function hindi Playlist
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
Check more vlookup video on same
How to switch over to next column for vlookup function
Learn vba..www.ajayparmartutor.com is my website
Hi that is too good, but I want to know is it possible to use vlookup with match function
Yes.. Check Playlist excel vba functions
Hello... what if the range is dynamic? how that willwork?
Hi Jorge... In that case you need to mix vlookup with Loops. You can use for next loop. I have basic and Advance videos on Loops, if you need to get more understanding. Watch Playlist.. Excel vba Loops... Start first with basics.however I will upload the video on same as well... Good luck... Keep watching..
I uploaded video no 275 .. please have a look.
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....!!
👍👍👍👍👍
can you please tell me how to use this for multiple columns vlookup
Please check other vlookup hindi language video under Playlist excel vba functions..
Sir, Kudos to you! Amazing ! What if we want to leave the cell blank instead of not found , so we can = "" ?
Yes.. You can..
How to create macro combination vlookup and if?
This way I won't be able to give you example. Do you have specific data to experiment
Yes i have, how could i show to you
hI AJAY , am unbale to find ur series since begining , i.mean.. how to use vlookup in VBA..biginner to advance