Nov 25 2023 05:50 PM
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 25 2023 08:33 PM
Solution
=LET(
xlp, XLOOKUP([@[Genius ID]], Genius!AN:AN, Genius!P:P, ""),
IF(ISBLANK(xlp), "", xlp)
)
Nov 26 2023 07:27 AM
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
Nov 25 2023 08:33 PM
Solution
=LET(
xlp, XLOOKUP([@[Genius ID]], Genius!AN:AN, Genius!P:P, ""),
IF(ISBLANK(xlp), "", xlp)
)