Format the cell to wrap text:

FormatCellsAlignment tabWrap textOK


--
Biff
Microsoft Excel MVP


"VLOOKUP-data formatting" <VLOOKUP-data
wrote in message
...
In my data table I used Alt-Enter to include multiple lines of info for
each
vendor. I used the VLOOKUP function but the results are returned with a
box
separating each line of info rather than returning the info in the same
format. Is there a way to get the info returned in the same format as the
original data table?

Thanks