In working with the problem I put in some wrapped text on the input sheet... it did not wrap on the sheet with the lookup formula.... Had to leave for awhile.. saved and closed... came back opened the workbook and the text was wraped on both sheets... It works but I don't understand why it would not show right without saving and closing...

I checked it in both excel 2000 and 2007.. It was the same..

Why?

Thanks Randy