vlookup #N/A error

T

tmurcer

I am receiving the #N/A error when trying to run a vlookup. I have run
into this before, and have typically been able to convert the cells to
like formatting in order to fix. It didnt work this time.

Both files that I am working with came from external sources. One of
the files would not allow me to autofit the column. I suspect there
are additional hidden spaces at the end of my text.

let me know if more info is required to assist. thanks,
 
D

Dark_Templar

Try this:

=IF(ISERROR(vlookup(…))=TRUE,"",vlookup(…))

(It says: If Vlookup is giving an error, put in a "" (blank), if it
does not give an error, it does the actual look up)
 
Top