Not sure what you're looking for. If Index() references an empty cell,
the value returned *is* 0.


In article ,
M.A.Tyler <Great Lakes State wrote:

=IF(A25=9,"",INDEX(CLM10000!$A$1:$R$640,MATCH(Shee t1!H25,CLM10000!$B$1:$B$640,
0),MATCH(Sheet1!$BX$6,CLM10000!$A$1:$R$1,0)))

Normally this works very well. The one problem I have experienced is when
the Index, Match portion references an empty cell. What do I need to add to
have this situation return "0". This way (my hope is) that subsequent
calculations won't return #value! errors. I understand =IF(A25=9,"" will
return a blank cell, however if this is the case then that cell would not be
used in any subsequent calculations.

Thanks Again!

M.A.Tyler