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...
LOOKUP returns an approximate match. Use VLOOKUP instead (or XLOOKUP, if you have Microsoft 365).
In sheet #2, cell D2:
=IFERROR(VLOOKUP(A2, 'FY17 MFP'!$A:$D, 4, FALSE), "")
Fill down.