I have a workbook with multiple sheets that use an index formula. I have cells with the index formula formatted to wrap text and have autofit the row height. When the formula returns data it does not automatically adjust the row height. I am able to select the row and autofit, and then it will adjust the row height. If I remove the data that is indexed, it does not shrink back down when that cell does show anything. If I get rid of the formula and type manually, it will wrap and adjust the row height automatically.
How can I get this to work and still use my formulas?