VLOOKUP - how to avoid the #N/A result

k-real

New Member
Joined
Jul 21, 2005
Messages
32
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...
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
=if(iserror(VLOOKUP(D9,'[Book1.xls]2006'!$M:$N,2,FALSE),"",VLOOKUP(D9,'[Book1.xls]2006'!$M:$N,2,FALSE))
 

Watch MrExcel Video

Forum statistics

Threads
1,114,676
Messages
5,549,374
Members
410,911
Latest member
AniEx
Top