Vlookup NA#
 

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.

Vlookup NA#
 

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

"Stormcloud" wrote in message
...
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.