Hi,
You are missing a closing parens in the formula and I usually use ISERROR.

=IF(ISERROR(VLOOKUP($A6,'Sept 9'!$A$1:$U$47,14,FALSE)),"",VLOOKUP($A6,'Sept
9'!$A$1:$U$47,14,FALSE))

HTH
--
Ken Hudson


"AZExcelNewbie" wrote:

I need to replace the #N/A values to be blank within a VLOOKUP formula. How
do I do this?

I've tried the following but excel doesn't seem to like it:

=IF(ISBLANK(VLOOKUP($A6,'Sept 9'!$A$1:$U$47,14,FALSE),"",(VLOOKUP($A6,'Sept
9'!$A$1:$U$47,14,FALSE))