Good morning, I hope you're all well!
I'm using XLOOKUP for the first time and having an issue where when I sort the data in this column by A to Z, it's putting all the blanks first, and the data I want at the bottom of the table.
This has never happened in the past (where I've used VLOOKUP for instance), and doesn't happen with any other columns with formulas in.
I've tried the following:
and:
Everything I try, this particular column sorts blanks, rather than visible data.
I'm stumped.
If anyone can help, it would be greatly appreciated.
Thank you.
Regards
Marhier
I'm using XLOOKUP for the first time and having an issue where when I sort the data in this column by A to Z, it's putting all the blanks first, and the data I want at the bottom of the table.
This has never happened in the past (where I've used VLOOKUP for instance), and doesn't happen with any other columns with formulas in.
I've tried the following:
Excel Formula:
=IF(ISBLANK([@CATEGORY]),"",XLOOKUP([@CATEGORY],Budgets[Category],Budgets[Material/Plant]))
Excel Formula:
=LET(X,XLOOKUP([@CATEGORY],Budgets[Category],Budgets[Material/Plant],""),IF(X="","",X))
and:
Excel Formula:
=IF(XLOOKUP([@CATEGORY],Budgets[Category],Budgets[Material/Plant],"")="","",XLOOKUP([@CATEGORY],Budgets[Category],Budgets[Material/Plant],""))
Everything I try, this particular column sorts blanks, rather than visible data.
I'm stumped.
If anyone can help, it would be greatly appreciated.
Thank you.
Regards
Marhier