keep getting zero instead of empty cell

  • Thread starter Thread starter dutty2001
  • Start date Start date
D

dutty2001

=INDEX(TABLE.xls!$A$1:$AQ$500,MATCH(B1,TABLE.xls!$A$1:$A$500,),MATCH("Drawin
Number",TABLE.xls!$A$1:$AQ$1,))

This is the formula that I've been using to pull the matching value i
the column "Drawing Number" from TABLE.xls, based on what I type i
cell B1. This all works fine until the corresponding cell for Drawin
Number is blank. I want to be able to specify what shows up in th
cell in my new sheet when the other cell is blank. Even if it's just
blank space that's what I want to show up.

So I did some research on this board and am using the following formul
with an IF statement.

=IF(ISERROR(MATCH(B1,TABLE.xls!$A$1:$A$500,)),"",INDEX(TABLE.xls!$A$1:$AQ$500,MATCH(B1,TABLE.xls!$A$1:$A$500,),MATCH("Drawin
Number",TABLE.xls!$A$1:$AQ$1,)))

But I don't think this IF statement is helping me, because I'm no
getting an error when the other cell is blank, I just get the numbe
zero placed in the cell. The zero shows up whether the IF statement i
added or not. So while my formula calls for a error to happen befor
the statement will run, I'm not getting an error, just this zero tha
won't go away. This is really bugging me, PLEASE SOMEONE HELP!!

Danie
 
I don't know how to make the zero actually go away, but
you could not look at it by using conditional formatting
to tell it to make the font white when the cell value is
equal to zero.
 
Hi,
Try the following
=IF(INDEX(...)="","",INDEX(...))
in addition I would add a '0' as the 3rd parameter for the MATCH
function to look for exact matches.

HTH
Frank
 
Try

=IF(INDEX(TABLE.xls!$A$1:$AQ$1,MATCH("Drawing
Number",TABLE.xls!$A$1:$AQ$1,))=0,"",your_other_formula))

or use custom format

General;-General;;

to hide any zeros
 
I did the ;; thing under "custom" and ALL numbers vanished, not only Zero
????????????
 
Back
Top