Replace a vlookup #N/A result with a value

Brandon · Aug 9, 2007

What formula can I use to replace a vlookup #N/A result with a value?

Toppers · Aug 9, 2007

=if(isna(vlookup formula),"your value",vlookup formula)

HTH

Tevuna · Aug 9, 2007

In versions 2007 use
=IFERROR(VLOOKUP(arguments),"Your value")