janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 117
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I don't know I can't get this formula to work. This is doing an XLOOKUP against another file, to return the "Title" if there is one, and if the field is BLANK, then it returns "Review." However, if the person does not exist on the source file, it is coming back as an error "N/A" - Instead of the error, I am want it to come back blank, but not sure why my formula isn't work.
I started with an IF statement with the XLOOKUP to return the title from the source file, then if it was blank, it will return a "Review" - then I added that if it's an ERROR (because there is no data in the source) that it would return BLANK, but it keeps returning the error "#N/A." What am I doing wrong with the formula?
FORMULA:
=IF(XLOOKUP(B4,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$B:$B,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$AD:$AD)="","Review",IFERROR(XLOOKUP(B4,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$B:$B,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$AD:$AD),""))
I started with an IF statement with the XLOOKUP to return the title from the source file, then if it was blank, it will return a "Review" - then I added that if it's an ERROR (because there is no data in the source) that it would return BLANK, but it keeps returning the error "#N/A." What am I doing wrong with the formula?
FORMULA:
=IF(XLOOKUP(B4,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$B:$B,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$AD:$AD)="","Review",IFERROR(XLOOKUP(B4,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$B:$B,'[Promotion Recommendations -Final.xlsx]Promo Recommendations'!$AD:$AD),""))