Xlookup Returns 0 Instead Of Blank

XLOOKUP return blank if blank Excel formula Exceljet

Xlookup Returns 0 Instead Of Blank. Web i want xlookup(10.0.2.0/24,$a:$a,$b:$b,,0) to return a blank, but since the search text is.

XLOOKUP return blank if blank Excel formula Exceljet
XLOOKUP return blank if blank Excel formula Exceljet

Web i want xlookup(10.0.2.0/24,$a:$a,$b:$b,,0) to return a blank, but since the search text is.

Web i want xlookup(10.0.2.0/24,$a:$a,$b:$b,,0) to return a blank, but since the search text is. Web i want xlookup(10.0.2.0/24,$a:$a,$b:$b,,0) to return a blank, but since the search text is.