XLOOKUP result for blank values is 0

In XLOOKUP, the ability to use if_not_found is great, however, what might I do if the value is found, but the result is blank? For example:

A:Subnet B:Description
10.0.1.0/24 Basement
10.0.2.0/24
10.0.3.0/24 Upstairs

I want XLOOKUP("10.0.2.0/24",$A:$A,$B:$B,"",0) to return a blank, but since the search text is found (but there's nothing in the result), the result displays a 0. I want it to be blank if either the search text is not found or if the resultant set is empty. Neither my tinkering nor my Googling has not borne fruit... thoughts?

1 Answer

Add &"" after the formula. For example:

XLOOKUP(C3,B6:B10,E6:E10)&""

(@Scott Craner's helpful comment formatted as an answer)