VLOOKUP - how to avoid the #N/A result

[k-real]

Hello everyone,

I've been trying to extract values from a different spreadsheet than the one where the formula following is:
=VLOOKUP(D9,'[Book1.xls]2006'!$M:$N,2,FALSE)

It does work fine, when it finds the value in $M, but when it doesn't - it returns #N/A. Is there a way it would just display nothing? I need this to sum afterall and the #N/A result doesn't quite help the case...

 

[SteveO59L]

=if(iserror(VLOOKUP(D9,'[Book1.xls]2006'!$M:$N,2,FALSE),"",VLOOKUP(D9,'[Book1.xls]2006'!$M:$N,2,FALSE))

 

[sooroo]

There are lots of solutions in this post too

http://www.mrexcel.com/board2/viewtopic.php?t=62102&highlight=result