Replace ISBLANK with ISERROR. Also, it looks like you're missing the ending
) for your ISBLANK function (posting error perhaps).
"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))
|