XLOOKUP() returns "0" instead of "empty cell"

Copper Contributor

I have to use CORREL() with 2 XLOOKUP but XLOOKUP returns "0" instead of "empty cell" so the result is incorrect. How can i make it return "empty cell" from "empty cell"?

1 Reply

@Davide230 

That's an irritating behavior of formulas in general. You can change the XLOOKUP formulas to

 

=IF(XLOOKUP(...)="", "", XLOOKUP(...))