Vlookup NA#

S

Stormcloud

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.
 
B

Barb Reinhardt

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top