janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 117
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I'm trying to add an IFERROR into this formula, but no matter where I put it, it keeps giving me an error. I am just trying to remove the "#N/A" to be blank if it's an error or be blank if it's blank.
Current formula:
=IF(XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H)="","",XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H))
Current formula:
=IF(XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H)="","",XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H))