Hi all,

I have a worksheet using a vlookup based on data validation. I want to do
one of two things with my result. One, I would like the cell with the
formula:

=IF(B6="","",(VLOOKUP(B6,Position,2,0)))

To autofit to the text returned, which would be something like this(this is
the result of my range named "Position", which is already formatted with the
Alt+Enter line breaks):

Ascent 7.5
SIS
OnBase
3270

I have wrap text enabled in cell B8, which is where my formula lies, but it
does not wrap the text unless I manually go into formatting, uncheck wrap
text and recheck wrap text.

Two, my other option which I would be perfectly happy with is if my vlookup
cell B8, could take the return info formatted like this:

Ascent 7.5, SIS, OnBase, 3270

and turn it into this:

Ascent 7.5
SIS
OnBase
3270

And Autofit the contents to the cell with the formula in it.

Basically my big problem is that I cannot get my cell with the formula in it
to wrap text, or autofit the contents it populates with based on the lookup
results. I hope this is sort of clear. Thanks in advance for any
suggestions.

--
Jon M.