Vlookup with VBA - Excel VBA Tutorial By Exceldestination

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

[@effiedsouza]

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

[@ExcelDestination]

Thanks for your appreciation!

[@MohAboAbdo]

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

[@alializadeh8195]

مرسی

[@MouseTrack]

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]

Thank you so much 🙂

[@Aetius034]

Thanks mate. Very instructive.

[@AjinkyaPendharkar]

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.

[@mesharibuhadi1437]

Great tutorial man thanks for the knowledge :D

[@prasu.gorgeous3779]

Wt is the multi sheet vlookup vba code

[@OmarAl93]

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

[@masoodmd6727]

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

[@PeggywongPeggy]

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

[@sanjaygorivale4938]

i want same example solve using multiple sheet plssss

[@aninayan3543]

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

[@akshunithy]

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

[@ExcelDestination]

welcome

[@khaisarbegum2134]

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

[@vijenderkumar55]

Very helpful for beginners

[@jasonfernandez6351]

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]

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 [e-mail]....I will definitely try to help you...Thanks again...keep watching an sharing!

[@b.deepika913]

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

[@mahendraprajapati9809]

Nice Video Thank you

[@hazemali382]

BOOM graet please we need workbook in description

[@prashanthkumar2381]

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

[@AllForChristYouthMission]

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

[@rachidlahdachi4615]

You help me, thank you very much

[@ExcelDestination]

Welcome

[@deepaksonu7127]

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]

Sorry sir vimal ji ab nahi rahe

[@k.k.sabariraj6484]

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.

[@relaxingnlearning5191]

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]

Please do reply

[@ExcelDestination]

You can take some help from the following tutorial :
ruclips.net/video/Dx_OfiBhHfw/видео.html

[@relaxingnlearning5191]

@@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]

Please help me

[@Marwan_Irwansyah]

if source data different or use another document can?

[@ExcelDestination]

yes, some modification would be required in this.

[@AJ_Gangaji]

i am geeting syntax error

[@kediadinesh]

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]

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]

@@ExcelDestination thanks

[@akshaytapadiya2239]

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

[@ExcelDestination]

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

[@sunilsahoo1951]

How to give dyanamic range instead of 3 to 9

[@ExcelDestination]

you can check another tutorial for creating dynamic range using row and column. Link is :
ruclips.net/video/6edvmcCvCkA/видео.html

[@shankhasubhramukherjee2043]

Too much helpful

[@ExcelDestination]

Glad to hear that

[@JATINKUMAR-qu4vi]

Thank u

[@2698638]

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

[@ExcelDestination]

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 [e-mail]..I will send you the code...

[@rameshd6815]

Very useful

[@ExcelDestination]

Thanks

[@4thOfficer]

thank you

[@ExcelDestination]

Welcome!

[@mertvak]

thanks indian guy, your accent if very bearable.

[@jyotitiwari9665]

Its not clearly visible

[@arvindsatyamaths7373]

मोबाइल यूजर्स के हिसाब से भी वीडियो बनाया करें प्लीज। मोबाइल में इतने छोटे अक्षरों में कोई फार्मूला नहीं दिखता। कृपया फार्मला ZOOM करके दिखाया करें।

[@ExcelDestination]

Sure :) next time...thanks for watching...if you need any help on vba programming, you can write to [e-mail]...

[@MrKhaldonalali]

احكي هندي وترجمها كتابة..!! وبلا انكليزيتك اللي بتوجع الراس..كل ما فتحنا فيديو بيطلعلنا هندي عبيحكي انكليزي..حكو لغتكم وبلاها الانكليزي تبعكن..