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:
‘ 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)”