vlookup NA

[Joelinnh]

Vlookup returning NA in cell

I need to have the NA be blank.

The sheet in the workbook is not in place yet till next Monday. Once the payroll sheet is added to the book then it would give information. Until the sheet is entered I want it to come back with a blank.

Currently looks up a name from A4 then goes to sheet and returns whats in coluum 9. with out the sheet I get NA. HELP

=IF(VLOOKUP($A4,'WW382011'!$A$2:$L$2252,9,FALSE)="",0,VLOOKUP($A4,'WW382011'!$A$2:$L$2252,9,FALSE))

 

[cb12]

Try:

=IFERROR(IF(VLOOKUP($A4,'WW382011'!$A$2:$L$2252,9,FALSE)="",0,VLOOKUP($A4,'WW382011'!$A$2:$L$2252,9,FALSE)),"")