Comparing values of two Excel sheets [Solved/Closed]
issa -
Mar 1, 2010 at 03:02 AM - Latest reply: dh
- Jun 10, 2017 at 09:04 AM
- Comparing values of two Excel sheets
- How to compare data in two excel sheets (Solved) » Forum - Excel
- How to Compare Two Excel Sheets and Combine Unique Data » How-To - Excel
- Compare values of two separate sheets and returning value [Solved] (Solved) » Forum - Excel
- How to compare two Excel sheets with varying data [Solved] (Solved) » Forum - Excel
- Excel - Comparing columns from different sheets » How-To - Excel
2 replies
Best answer
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 ""
has helped 1805 users this month
Report
just what doctor ordered thank you