software

My vlookup formula is referencing another active spreadsheet and is returning
'NA#' when there is a value in the cell being referenced. Can someone tell
me how to fix it so that it returns the value that is in the referenced cell?
I've checked the formula and it is correctly written.

You could have a space or some kind of hidden character on one that you
don't have in the other.

quot;Stormcloudquot; gt; wrote in message
...
gt; My vlookup formula is referencing another active spreadsheet and is
gt; returning
gt; 'NA#' when there is a value in the cell being referenced. Can someone
gt; tell
gt; me how to fix it so that it returns the value that is in the referenced
gt; cell?
gt; I've checked the formula and it is correctly written.