Forum Discussion
XLOOKUP lookup value is formula doesn't work
Hello I have an xlookup formula with lookup value to a cell that has a formula in it. The xlookup returns #N/A when looking at the formula, but if I type a value in the cell it works... why won't ...
Better to check the sample, as variant formula could return text "1" and you type number 1; formula could return text with extra space or other symbol "abc " and you type "abc", etc.