bloubul
Member
Will some one please help me.
I'm using this formula "=IF(COUNT(C5)=0,"",INDEX($Q4:$BI4,0,C5))", as long as there are only numbers (1_49) in C5:G5 the formula works great, but if I put a "0" in C5:G5, than it gives me "####" in J5:N5, but the "INDEX($Q4:$BI4,0,C5))" part works fine it see the "0" and count it, it's the front part of the formula that gives me problems.
Thanks
BlouBul
I'm using this formula "=IF(COUNT(C5)=0,"",INDEX($Q4:$BI4,0,C5))", as long as there are only numbers (1_49) in C5:G5 the formula works great, but if I put a "0" in C5:G5, than it gives me "####" in J5:N5, but the "INDEX($Q4:$BI4,0,C5))" part works fine it see the "0" and count it, it's the front part of the formula that gives me problems.
Thanks
BlouBul