jonybandana
New Member
- Joined
- Dec 16, 2022
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
Hello! So I Have a table with an Xlookup formula. The formula goes something like this:
=xlookup([@Number];QueryTable[Numbers];QueryTable[Supplier];"-";0;1)
In some cases, when I excecute the formula, it will display either "-" or the cell will be empty, but there is data to be found on QueryTable.
As some bonus information, whenever I use the search function on the table, and I look for the Number in which the formula is not updating, the cell that should return the value is filled.
Is this a common issue?
=xlookup([@Number];QueryTable[Numbers];QueryTable[Supplier];"-";0;1)
In some cases, when I excecute the formula, it will display either "-" or the cell will be empty, but there is data to be found on QueryTable.
As some bonus information, whenever I use the search function on the table, and I look for the Number in which the formula is not updating, the cell that should return the value is filled.
Is this a common issue?