Vlookup with VBA - Excel VBA Tutorial By Exceldestination

Рет қаралды 90,136

Күн бұрын

This Example explains, how to use Vlookup Function with VBA Programming. We can automate VLookup with the help of VBA in Excel.

Пікірлер: 60

@MohAboAbdo 4 жыл бұрын

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

@effiedsouza 6 жыл бұрын

Hi! This was excellent!!! Went through so many videos and eventually learned vlookup in VBA from your video ! Thanks a lot.. 😊

@ExcelDestination 6 жыл бұрын

Thanks for your appreciation!

@Aetius034 4 жыл бұрын

Thanks mate. Very instructive.

@MouseTrack 3 жыл бұрын

Nice way of presentation. No unwanted "details and explanations" Good for those who are looking for the corr of the tutorial. Really great one...👍🏼

@ExcelDestination 3 жыл бұрын

Thank you so much 🙂

@mesharibuhadi1437 Жыл бұрын

Great tutorial man thanks for the knowledge :D

@OmarAl93 2 жыл бұрын

Hi i appreciate the help and the amazing content. Is it possible to apply the same vLookup process you did but on filtered table? Eventually, how can we make the filtered table rows number dynamic (so we can assign a variable to i in for function)? I’d appreciate your assistance a lot, as I’m trying to create a macro that copies value from monthly report to big master file after filtering some rows Best, Omar

@alializadeh8195 2 жыл бұрын

مرسی

@vijenderkumar55 3 жыл бұрын

Very helpful for beginners

@akshunithy 2 жыл бұрын

Thanks for your video 🤩🤩🤩 It's really timely help

@ExcelDestination 2 жыл бұрын

welcome

@AjinkyaPendharkar 3 жыл бұрын

Sir, when I am applying this to my excel having 55000 rows the excel is hang and it is applying V Lookup in back end, but it takes too much of time i.e. more than 1 hour. Kindly suggest.

@jasonfernandez6351 6 жыл бұрын

Hi! I just want to ask what data type i will be using if my lookup value in a textbox contains more than 15 numbers. I received a runtime error 6 every time i run the macro. Thanks in advance for your response. God bless!

@ExcelDestination 6 жыл бұрын

Hi Jason, Thanks for your appreciation! Here, I would say that from vlookup's point...data should be in same format for lookup value and in table array...in VBA we are considering a cell value as lookup value and in your case (as far as I could think of) text value should be of same format as it is in data...please try to check the formatting of value...if it doesn't work...you can send me your file with user form with some dummy data...at EXCELDESTINATION@GMAIL.COM....I will definitely try to help you...Thanks again...keep watching an sharing!

@sanjaygorivale4938 5 жыл бұрын

i want same example solve using multiple sheet plssss

@prasu.gorgeous3779 5 жыл бұрын

Wt is the multi sheet vlookup vba code

@PeggywongPeggy 4 жыл бұрын

Hi Sir May I hv the code, trying to read and understanding

@mahendraprajapati9809 Жыл бұрын

Nice Video Thank you

@masoodmd6727 2 жыл бұрын

nice but how can we make the loop dynamic, 9 rows are hard coded

@relaxingnlearning5191 4 жыл бұрын

Nice video and very helpful indeed. However I just want to know what if I have to get the data from a different workbook what change would VBA code have to incorporate?

@relaxingnlearning5191 4 жыл бұрын

Please do reply

@ExcelDestination 4 жыл бұрын

You can take some help from the following tutorial : kzfaq.info/get/bejne/et6Pgsmap86slqs.html

@relaxingnlearning5191 4 жыл бұрын

@@ExcelDestination I tried to do that but doesn't work Sub finding_value() On Error Resume Next On Error GoTo me: Sheets("FIND").Select Dim i As Long For i = 1 To Range("B100000").End(xlUp).Row Range("C" & i).Value = WorksheetFunction.VLookup(Range("B" & i).Value,[firstworkbook.xlsx]DATABASE!R2C[-2]:R15C, 2, 0) 'Range("a2").Value = WorksheetFunction.VLookup(Range("b4").Value,SHEET1.RANGE("A1:C15"), 2, 0) Next Exit Sub Me: Range("b" & i).Value = "NOT FOUND" Resume Next End Sub

@relaxingnlearning5191 4 жыл бұрын

Please help me

@aninayan3543 4 жыл бұрын

urgent help for vlookup code for separate workbook and sheets!!!!!pls help

@khaisarbegum2134 2 жыл бұрын

Hi sir,I am Facing error like unable to get the vlookup property of the worksheetFunction class,pls help me to resolve this

@shankhasubhramukherjee2043 3 жыл бұрын

Too much helpful

@ExcelDestination 3 жыл бұрын

Glad to hear that

@rachidlahdachi4615 2 жыл бұрын

You help me, thank you very much

@ExcelDestination 2 жыл бұрын

Welcome

@hazemali382 4 жыл бұрын

BOOM graet please we need workbook in description

@b.deepika913 2 жыл бұрын

Hi bro Can we do two or three columns at a time?? With this script If yes then what changes should i do in script Plzzzz help

@prashanthkumar2381 5 жыл бұрын

i am getting run-time error'1004' unable to get the vlookup property of the worksheet function class .. kindly help me

@AllForChristYouthMission 5 жыл бұрын

i'm having the same issue, can you help?

@akshaytapadiya2239 4 жыл бұрын

Hi sir, Thanks for the video If value not found then macro is stopping their only, it should continue further living NA there

@ExcelDestination 4 жыл бұрын

..........I would not recommend......however you can write one line "On error resume next..........it will solve the problem.

@deepaksonu7127 3 жыл бұрын

I tried this code but it failed. my lookup value is blank for few cells and I want vlookup function to work where ever I have data . can u pls guide me . I watched another video where he says that we shouldn't use worksheet.application.Vlookup function if your data has some missing information or that is not present in the lookup range ..? Is this correct?

@ExcelDestination 3 жыл бұрын

Sorry sir vimal ji ab nahi rahe

@kediadinesh 3 жыл бұрын

Sir Is it possible that my specific excel file opens in my system only. If any person copy that file It can not open in another system.

@ExcelDestination 3 жыл бұрын

I can suggest you the logic, you can try. You can write code in "Workbook Open" event to check the IP Address \ Computer address and if it is different to your system then file should be closed automatically.

@kediadinesh 3 жыл бұрын

@@ExcelDestination thanks

@Marwan_Irwansyah 3 жыл бұрын

if source data different or use another document can?

@ExcelDestination 3 жыл бұрын

yes, some modification would be required in this.

@JATINKUMAR-qu4vi 2 жыл бұрын

Thank u

@k.k.sabariraj6484 2 жыл бұрын

hi sir, thank you for this video presentation. here I need one more vba code for this formula =if(a2=VLOOKUP(a2,table1,1,true),VLOOKUP(a2,table1,2,true),"NA") applying this formula for the above 4 lacks data we vlookup the values from the next sheet table data waiting for your code thank you.

@rameshd6815 2 жыл бұрын

Very useful

@ExcelDestination 2 жыл бұрын

Thanks

@4thOfficer 3 жыл бұрын

thank you

@ExcelDestination 3 жыл бұрын

Welcome!

@sunilsahoo1951 4 жыл бұрын

How to give dyanamic range instead of 3 to 9

@ExcelDestination 4 жыл бұрын

you can check another tutorial for creating dynamic range using row and column. Link is : kzfaq.info/get/bejne/bMuUqdCUqNynm3U.html

@2698638 6 жыл бұрын

Isn't it possible to let us download the file?

@ExcelDestination 6 жыл бұрын

Hi Steven, Thanks for watching! I am working on my Blog and soon it will be live...where anyone can download code etc....till then...if you need the code of this...you can send email to me on EXCELDESTINATION@GMAIL.COM..I will send you the code...