Hello,
I am looking for a VBA code to compare 3 columns in 3 different sheets (sheet1,sheet2,sheet3).
Below is my formula that I am using but its just not efficient.
IF(ISNA(VLOOKUP(sheet1!B:B,sheet2!D:D,sheet3!C:C,1,FALSE)),sheet1!B:B,"")
My goal here is to compare the 3 sheets and if any results do not match sheet1 , paste them into column A sheet 4
thank you in advance
I am looking for a VBA code to compare 3 columns in 3 different sheets (sheet1,sheet2,sheet3).
Below is my formula that I am using but its just not efficient.
IF(ISNA(VLOOKUP(sheet1!B:B,sheet2!D:D,sheet3!C:C,1,FALSE)),sheet1!B:B,"")
My goal here is to compare the 3 sheets and if any results do not match sheet1 , paste them into column A sheet 4
thank you in advance