hi experts
first of all my real data are at least 10000 rows and I attach a simple file with the simple data to understand what I want after match data sheet1 for COLS B,C,E,F with sheet2 for COLS B,C,D ,E if are matched it should replace values in sheet2 for COL E with COL F in sheet1 the result should show in sheet1 in COL F I put the result in sheet expected result
Bookmarks