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...
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...