An #N/A (missing data) populates a vlookup answer cell if the information is not found in the lookup table for an exact match (and I don't want to use a fuzzy TRUE match). This error message (the #N/A)prevents that cell from being useable (columns won't add and I haven't figured out how to eliminate it with IF statements buried in the vlookup statement either). Any suggestions how to work around this dreaded missing data issue?

Thanks!
Linda

Linda Decker