I have two excel files, file1 has some 5+ email ids in different columns and file 2 has one email id with few columns included.
I wanted to compare file1 information with file2 if it matches then it has to be written in the separate file.
is it possible to check 5 different values from one row with the another value from another file
i am attaching the sample files here. kindly help me building this logic.
Here in the file 1 all the email id’s from column2, column4, column6, column8 and column10 has to be compared with preferred name email address of all three sheets from file 2. if any one of the email id from file is matched then it has to be written in the output file as file 2 (that is matched record filtration).
Kindly let me know for any further clarifications .
It is quite urgent, please help me,