crayroge
New Member
- Joined
- Mar 17, 2020
- Messages
- 9
- Office Version
- 2016
- 2010
- Platform
- Windows
- Mobile
- Web
I use this formula to give a more detailed match between two different spreadsheets. For some reason, when the data doesn't match instead of the formula saying "NO" its saying #N/A...should I incorporate the IFERROR function?
=IF(INDEX(Sheet1!A:A,MATCH('Temp ANF'!A2,Sheet1!C:C,0))='Temp ANF'!A2,"NO","YES")
=IF(INDEX(Sheet1!A:A,MATCH('Temp ANF'!A2,Sheet1!C:C,0))='Temp ANF'!A2,"NO","YES")