J
Jon M.
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.
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.