Forum Discussion

Ron_Hockman1525

Copper Contributor

Nov 26, 2023

Solved

Xlookup

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

Formulas and Functions

Hi Ron_Hockman1525

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

3 Replies

Lorenzo
Silver Contributor
Nov 26, 2023
Hi Ron_Hockman1525

=LET( xlp, XLOOKUP([@[Genius ID]], Genius!AN:AN, Genius!P:P, ""), IF(ISBLANK(xlp), "", xlp) )
- Ron_Hockman1525
  Copper Contributor
  Nov 26, 2023
  Brilliant. Thanks so much for your help.
  - Lorenzo
    Silver Contributor
    Nov 26, 2023
    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

Resources