Getting rid of #N/A

[mrskidder]

I have a worksheet that I'm using a VLOOKUP function to pull information in from other spreadsheets. Some of the names that I'm looking up aren't on the worksheets that I'm looking on and therefore those cells return a #N/A. How would I fix my formula so that those cells would just be 0?

Here is the VLOOKUP function that I'm using:

=VLOOKUP(B96,'[U8E 401k Report 6-05-15.xls]Rows 1 to 87'!$A$1:$T$88,17,FALSE)

 

[FormR]

Hi - try:

=IFERROR(VLOOKUP(B96,'[U8E 401k Report 6-05-15.xls]Rows 1 to 87'!$A$1:$T$88,17,FALSE),0)

 

[mrskidder]

Perfect!! Thank you!