Vlookup NA#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top