Hello All,
Can anyone please help me on below requirement it would be very helpful it me as i am stuck
My requirement is bit complex explaining you in detail below:
Consider Workbook1 as input1
Workbook2 as input2
- Based on Distinct “SR-Name” column and for “Lead” , “Head” and “Account” as null in “Workbook1”
- Check the SR-Name in another “workbook2” which has the values for above null columns “Lead” , “Head” and “Account”.
- If SR-Name of “Workbook1” is not present in “Workbook2” then need to search for “Dept” and match both “Dept” in both workbooks and update the values from second workbook for “lead” head" account columns .
LIke Below:
Input1.xlsx (8.4 KB) Input2.xlsx (8.6 KB)