I have 2 excel files, one excel files with one sheet and the other file with three sheets.
Excel file1 has1 sheet with 30+ columns out of which only email id have to be compared with all the three sheets of the Excel file 2 and write back the matched mail id information with Excel file 1 data in result file.
Excel file 2 has 3 sheets with 5+ columns out of which email id is the one of the column that has to be compared with the Excel file 1.
Result file should have the matched email ids information as per excel file 1 information (i.e. 30+ column) from excel file 1 and excel file 2. Added to that the column 1 from excel file 2’s sheet 1 and sheet 2 has to be added. i highlighted the it as column 12 in yellow.Sample Files.zip (28.4 KB)
attaching the sample files for your perusal.
Your help is highly appreciated.