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:
drive.google.com/drive/folder...
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-xe7ej]

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.

[@NaveenTamtaIamExcelVBA]

VLook match is not working here?

[@marc-xe7ej]

@@NaveenTamtaIamExcelVBA I have source data workbook - job ID in column A Column B has inputs that match my headers exactly on the master form. Column C has Dates that the task was completed. I wan to match job ID and Header to the master sheet headers and job ID (job ID Column A and headers all on ROW 1 and write Column C date in corresponding col/row.

[@balachandral1055]

Very useful video ..Thanks sir

[@NaveenTamtaIamExcelVBA]

Thank you!!

[@rishabhkumar9208]

Thank you, this video helped me a lot ❣️

[@NaveenTamtaIamExcelVBA]

Thanks.. hope you have subscribed

[@rohanchristian3083]

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

[@NaveenTamtaIamExcelVBA]

Thank you!!

[@jonvesteenselvan1798]

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