Related:
- Comparing values of two Excel sheets
- Comparing data between two excel sheets ✓ - Forum - Excel
- Compare values of two separate sheets and returning value ✓ - Forum - Excel
- How to compare two excel sheets for differences in values vba ✓ - Forum - Excel
- Comparing Two Excel Sheets and copying like data to third sheet ✓ - Forum - Excel
- Comparing two excel worksheets ✓ - Forum - Excel
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
Use VLOOKUP formula in sheet 2
If your data starts in sheet 2 from A2 you can use
=IF(ISERROR(VLOOKUP(A2, Sheet1!A:A,1,FALSE)), "NOT FOUND", "")
If will say "NOT FOUND" if there is no match else would remain ""
If your data starts in sheet 2 from A2 you can use
=IF(ISERROR(VLOOKUP(A2, Sheet1!A:A,1,FALSE)), "NOT FOUND", "")
If will say "NOT FOUND" if there is no match else would remain ""
Report
dh
just what doctor ordered thank you
