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 ...
What error did you have? I am running into this exact problem. I am referencing a lookup value that contains a formula (=right(D4,5)) and my xlookup is giving me an error. I am not sure how to be certain that it is searching by the actual cell value.
As variant you lookup numbers on texts (which looks like numbers) returned by =right(D4,5). If so try
=--right(D4,5)
Whatever, it could be lot of other reasons. It's better to give more details starting the new discussion.