Nested XLOOKUP formula

[janema]

I am trying to get this formula using an XLOOKUP to bring back BLANK if there is an error or no data on the source, but it will only do one or the other. Tried it probably 8 different ways and I can't figure out why it won't work.

=IF(XLOOKUP(R4,'Radford (Life Science 04.2023)'!L:L,'Radford (Life Science 04.2023)'!EG:EG)="","",XLOOKUP(R4,'Radford (Life Science 04.2023)'!L:L,'Radford (Life Science 04.2023)'!EG:EG))
Above is the formula I entered last, but if you see the image, there are still "N/A" results coming back. The blank appears to be working for the most part of instances where the source just has a blank or no data.

 

[janema]

Another option is

=LET(x,XLOOKUP(R4,'Radford (Life Science 04.2023)'!L:L,'Radford (Life Science 04.2023)'!EG:EG,""),IF(x="","",x))

This worked! Thank you so much. I could never reenact this formula, but hope to learn some day soon. It worked for what I need now. THANK YOUUUU!

 

[Fluff]

Glad we could help & thanks for the feedback.