VLOOKUP, empty data cells and spreadsheet esthetics

[Guest]

My worksheet contains empty rows between groups of cells. How can I avoid the VLOOKUP function linked to another spreadsheet printing #N/A, DIV#/0 etc. if the reference cell in the worksheet is empty and the VLOOKUP formula-containing cells are filled by dragging? I've tried various tricks using IF without much success.

It's clear that if the reference cell is empty, nothing can be found in the Master spreadsheet, but that leads to a vixcious circle of #N/A's etc

z.entropic

 

[Peo Sjoblom]

One possible way

=IF(ISNA(MATCH(A1,'[other
spreadsheet.xls]MySheet'!$A$3:$A$15,0)),"",VLOOKUP(A1,'[other
spreadsheet.xls]MySheet'!$A$3:$B$15,2,0))

can't see how you can get div errors unless the lookup table itself contains
errors

--

Regards,

Peo Sjoblom

My worksheet contains empty rows between groups of cells. How can I avoid

the VLOOKUP function linked to another spreadsheet printing #N/A, DIV#/0
etc. if the reference cell in the worksheet is empty and the VLOOKUP
formula-containing cells are filled by dragging? I've tried various tricks
using IF without much success.

It's clear that if the reference cell is empty, nothing can be found in

the Master spreadsheet, but that leads to a vixcious circle of #N/A's etc.