How to wrap text returned from formula in Excel 2010?

Hi everyone,

I am pulling text into a cell using an IF statement and Index Match.

For example: IF(A1="","",INDEX('Sheet2'!A1:A5,MATCH('...

I have selected wrap text and autofit row height, but I still have to double click wrap to make it expand the row height. It doesn't do it automatically.

Any help would be greatly appreciated


Thanks!

Excel has never been very good at doing that.

Pete