Aravindhan Bharathi
New Member
Hi All,
Happy to be here.
Sorry for directly jumping to the question.
I have a source data, I need to do vlookup with 2 different workbooks. There are currently 5 columns to be updated on the source data from the 2 different workbooks. 3 columns are from first workbook and last two columns are from second workbook through VBA MACRO.
there is a issue on the vlook-up were I don't know how to proceed further,
1. were on the first look-up with the first workbook - it needs to update in the 3 columns on the source data and we have to apply what are not available in the first vlook-up that cases only we have to check on the second workbook.
Guidance please.
Source data - common reference in AB column after that 5 columns to be updated with vlook-upvalue.
First look-up with first workbook needs to update the AC,AD and AE column on source data
Second look-up with first workbook needs to update the AF and AG column on source data.
Happy to be here.
Sorry for directly jumping to the question.
I have a source data, I need to do vlookup with 2 different workbooks. There are currently 5 columns to be updated on the source data from the 2 different workbooks. 3 columns are from first workbook and last two columns are from second workbook through VBA MACRO.
there is a issue on the vlook-up were I don't know how to proceed further,
1. were on the first look-up with the first workbook - it needs to update in the 3 columns on the source data and we have to apply what are not available in the first vlook-up that cases only we have to check on the second workbook.
Guidance please.
Source data - common reference in AB column after that 5 columns to be updated with vlook-upvalue.
First look-up with first workbook needs to update the AC,AD and AE column on source data
Second look-up with first workbook needs to update the AF and AG column on source data.