VLOOKUP, empty data cells and spreadsheet esthetics

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

z.entropic said:
My worksheet contains empty rows between groups of cells. How can I avoid
Click to expand...
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
Click to expand...
the Master spreadsheet, but that leads to a vixcious circle of #N/A's etc.
 
Back
Top