Xlookup

[Ron_Hockman1525]

When I use this formula   =XLOOKUP([@[Genius ID]],Genius!AN:AN,Genius!P:P,"")

I am getting 0's for blank cells in the lookup.  How can I get results with just a blank instead of a zero?

Ty

[#2 · Accepted solution]

Hi @Ron_Hockman1525 

=LET(
  xlp, XLOOKUP([@[Genius ID]], Genius!AN:AN, Genius!P:P, ""),
  IF(ISBLANK(xlp), "", xlp)
)

[#3]

Brilliant. Thanks so much for your help.

[#4]

You're welcome @Ron_Hockman1525 

Feel free to click the Mark as solution link at the bottom of the solution to help those who Search - Thanks