Vlookup did cell auto formating but not displaying complete text..
 

Version- Excel 2000, Used Vlook upfunction on sheet 2 done formating row
autofit but still the result does not showcomplete info..

Hi
could you post your exact formula, the expected result and the actual result

--
Regards
Frank Kabel
Frankfurt, Germany

Roda wrote:
Version- Excel 2000, Used Vlook upfunction on sheet 2 done formating
row autofit but still the result does not showcomplete info..

Format the cells for wrap text (FormatCells, Alignment tab) and the
results should show.

Roda wrote:
Version- Excel 2000, Used Vlook upfunction on sheet 2 done formating row
autofit but still the result does not showcomplete info..


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html