Accepting Blank Cells

  • Thread starter Thread starter snoopy
  • Start date Start date
S

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'!D3:D476,MATCH(RECEIPT!D8,'Check Receipt
Log'!B3:B476,0))
 
You might try wrapping your formula in an IF statement, such as,

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

Vaya con Dios,
Chuck, CABGx3
 
I think I'd use:

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

just in case the formula was bringing back a real 0.
 
Good point Dave...........thanks for raising the issue.........

Vaya con Dios,
Chuck, CABGx3
 
Thanks guys the formula worked after adding some additional parentheses
You guys are awesome
 
Back
Top