Adding IFERROR into nested IF statement

[janema]

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))

 

[Sufiyan97]

Try

=IFERROR(IF(XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H,"",0,1)="","",XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H,"",0,1)),"")

 

[janema]

Try

=IFERROR(IF(XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H,"",0,1)="","",XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H,"",0,1)),"")

That almost worked, but it blanked out cells that should not be blank so it did something more than it should have.

 

[Sufiyan97]

Try

=IFERROR(IF(XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H)="","",XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H)),"")

 

[janema]

Try

=IFERROR(IF(XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H)="","",XLOOKUP(B7,'Comp Changes'!A:A,'Comp Changes'!H:H)),"")

Thank you so much. That worked!

 

[Sufiyan97]

You're welcome.
Happy to help.