Forum Discussion
Copy from one sheet to another but if differences leave cells blank
Hello, I have many sheets in my workbook. The data between the sheets is almost identical. I am looking for a formula that will compare column A in sheet 2 to column A in sheet 1. If the dat...
If with XLOOKUP()
=XLOOKUP(A:A,'FY17 MFP'!A:A,'FY17 MFP'!D:D,"")formula will return entire column. However, it's better to use concrete range, static or dynamic, like
=XLOOKUP(A1:A1000,'FY17 MFP'!A1:A1000,'FY17 MFP'!D1:D1000,"")