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
- Find matching values in two excel sheets ✓ - Forum - Excel
- Compare data from two excel sheets ✓ - Forum - Excel
- How to compare two excel sheets for differences in values vba ✓ - 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
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Create a Gmail Account