Forum Discussion

Ron_Hockman1525's avatar
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

3 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Hi Ron_Hockman1525 

     

    =LET(
      xlp, XLOOKUP([@[Genius ID]], Genius!AN:AN, Genius!P:P, ""),
      IF(ISBLANK(xlp), "", xlp)
    )
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor

        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