Accepting Blank Cells

[snoopy]

I have created a Receipt log on one workbook, which references another
workbook using the index match formula. The index match formula seems
to work as long as what I am indexing has text in the cell. If
however, the index portion is blank and the match portion has writing
then it will spit out a zero. Is there any way that my formula can
spit out a blank cell, if what is indexed is blank? I just dont want a
zero or any other error to pop up. My formula is below:

=INDEX('Check Receipt Log'!D3476,MATCH(RECEIPT!D8,'Check Receipt
Log'!B3:B476,0))

 

[CLR]

You might try wrapping your formula in an IF statement, such as,

=IF((yourformula)=0,"",(yourformula))

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

I think I'd use:

=IF((yourformula)="","",(yourformula))

just in case the formula was bringing back a real 0.

 

[CLR]

Good point Dave...........thanks for raising the issue.........

Vaya con Dios,
Chuck, CABGx3

 

[snoopy]

Thanks guys the formula worked after adding some additional parentheses
You guys are awesome