VLOOKUP MATCH from another workbook - VBA

#NaveenVBA, #NaveenTamtaIamExcelVBA, #vba

Hi Guys,

Here comes my new video on a real-life scenario in your day-on-day work. Such situations keep on coming and we spend hours to find the nearest solution for such particular problems.

Hence, I have made this video for you to understand the dynamic concept and implement the same in your workings.

Feel free to use the link below for accessing and downloading the practice files:

Tags :
vlookup to another workbook google sheets,
vlookup from another file,
excel vlookup from another workbook without opening,
vlookup formula,
xlookup from another workbook,
how to do vlookup in excel with two spreadsheets,
excel vba vlookup in another workbook without opening,
macro for vlookup multiple workbooks,
how to create a vlookup macro in excel,
vlookup from another workbook,
excel vba vlookup in another workbook with example,
vlookup in vba using multiple sheets,
vba code for vlookup with dynamic range,
vlookup in vba loop,

[marc-xeej]

this is an excellent video. It is almost exactly what i need.
workbook 1
I have a user form that is writing a serial number to col A, then has a Combo box with drop down selection of options which are a list of the headers from workbook 2 (columns b thru J). and then col 3 is a date of completion entry.

workbook 2
i would like to match workbook1 serial number to the same serial number in col A workbook 2
then match the result of col B workbook 1 to the headers of workbook 2 Col B - J and write the date of completion in the row of the serial number they entered.

[LinhHoang-rsku]

Excellent video Naveen.
If your source data have more than 1 sheet, how do you handle vlookup in exactly sheet?
Thank in advance!

[rohanchristian]

Too good bro... excellent video.. keep it up.👍👍

[rishabhkumar]

Thank you, this video helped me a lot ❣️

[jonvesteenselvan]

Bro i need the vlookup in vba, as i have need same source data