Thanks, but I think I figured it out as soon as I posted the question. I added &"" to the end of the formula like this =(INDEX(Analyze[#All],SMALL(IF(Analyze.Dog='3from analyze movavgtable'!$C$1,ROW(Analyze.Dog)),ROW(1:1)),10))&""

I'm checking to make sure it works through out the workbook.

Doug