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