How to wrap text returned from formula in Excel 2010?

[tr3kx]

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!