what are the results of the =ISNUMBER()On 2002-03-27 09:18, jcmeyer wrote:
I am having a problem using text data with the vlookup function. The lookup value is in text format and the first column of the data range is in text format. If I copy and paste the lookup value into the lookup value cell location, I get #N/A as a result of my vlookup function, even though the lookup value is in the first column of my data range.
If I type the lookup value into the the lookup value cell location, the function works fine. This isn't a solution that I can use, because I have a list of items to lookup and it would take too long to copy and paste the values and retype these values in the same cell.
Has anyone encountered this issue before?
formula, using the first value in your look up table, and the value you want to look up?
If they are both text, the results should both be false. A real "number" can reside in a cell formatted as text.