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 ...
Are the values really identical? Xlookup returns #N/A if the value cannot be found. If you manually type the value and that one can be found, then the initial value is not the same as what you typed.
Leading/trailing blanks can be one reason for the problem.
Can you post an example for inspection?