G
Guest
=IF(A25=9,"",INDEX(CLM10000!$A$1:$R$640,MATCH(Sheet1!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
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