How to perform Vlookup from Closed Workbook

How to perform a Vlookup from a closed workbook in Excel using VBA. We have earlier learnt how to Vlookup data, inventory management with Vlookup, getting multiple values using Vlookup, etc. Today we’ll learn how to get data from a closed workbook with Vlookup. The most important parameter in this Vlookup is the path to the closed workbook. Once we get the syntax for the path to the workbook right, everything else falls into place. Watch the video to learn how this goal can be achieved quickly and easily:


You can watch this video on YouTube also.

Here’s the complete VBA code to get data from a closed workbook with Vlookup:

Sub vlookupDatafromClosedWorkbook()

‘ How to Vlookup data from a closed workbook in a simpler manner
Range(“D2”) = “=VLOOKUP(RC[-3],(‘C:\exceltrainingvideos\[customers-email-mobile.xlsx]Sheet1’!R2C1:R10C3),2,FALSE)”
Selection.AutoFill Destination:=Range(“D2:D10”)
End Sub

Further reading:

Vlookup Function