Reggie Jardin
Member
Hi,
I uploaded 2 excel sheet with file name Master A and Master B spreadsheet (workbook).
I want a Macro on Master B sheet that will concantenate Column A to C and the result will display in column D.
Against that concantenation result of column D i want to vlook up that column D into Master A workbook column A with the result of Master A column B will displayed in workbook Master B column E.
Basically I want a macro logic that will concantenate 3 or more column and against that concantenation it will vlook up other file since that is the only common thing to both file but other file has need to do concantenation so that the vlookup will be successful.
Please find attached sample file.
I uploaded 2 excel sheet with file name Master A and Master B spreadsheet (workbook).
I want a Macro on Master B sheet that will concantenate Column A to C and the result will display in column D.
Against that concantenation result of column D i want to vlook up that column D into Master A workbook column A with the result of Master A column B will displayed in workbook Master B column E.
Basically I want a macro logic that will concantenate 3 or more column and against that concantenation it will vlook up other file since that is the only common thing to both file but other file has need to do concantenation so that the vlookup will be successful.
Please find attached sample file.