Comparing values of two Excel sheets
Solved/Closed
Related:
- Comparing values of two Excel sheets
- Mark sheet in excel - Guide
- Sheets right to left - Guide
- How to open excel sheet in notepad++ - Guide
- How to take screenshot of excel sheet on laptop - Guide
- Number to words in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 1, 2010 at 08:43 AM
Mar 1, 2010 at 08:43 AM
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 ""
Jun 10, 2017 at 09:04 AM