I have this crazy long formula, but its really not that complicated, a lot of the same stuff repeated... The formula does a check for values in column B8:B32 and proceeds to look in another sheet and report back values. The problem is, the data in B8:B32 is dynamic and sometimes contain zeroes...