I'm using a drop down list, data validation and vlookup on a spreadsheet. All
is working well EXCEPT when the cell populates with the the verbiage from the
vlookup, the cell will not word wrap, shrink to fit, auto adjust or format as
I request. I need to size the cell according to the amount of text being
referenced . Do I need to do something special?

Hi,

Normally the cell with the return value from a VLOOKUP would word wrap or
best fit (not automatically, but manually) If it is not, it is likely that
you have a hard carrage return in the text of the cell being returned. Also,
keep in mind if the cell with the VLOOKUP is a merged cell best fit will not
work. You might try
=CLEAN(VLOOKUP(A1,Table,3,False))
but its hard to say if that will help.

--
Thanks,
Shane Devenshire


"Bev-Roseland-NJ" wrote:

I'm using a drop down list, data validation and vlookup on a spreadsheet. All
is working well EXCEPT when the cell populates with the the verbiage from the
vlookup, the cell will not word wrap, shrink to fit, auto adjust or format as
I request. I need to size the cell according to the amount of text being
referenced . Do I need to do something special?

Thank you for this. I researched this in my Excel Bible and tried it. It
didn't hurt anything, but did not help my auto-size situation either. Awesome
suggestion and may help someone else, thank you.

"ShaneDevenshire" wrote:

Hi,

Normally the cell with the return value from a VLOOKUP would word wrap or
best fit (not automatically, but manually) If it is not, it is likely that
you have a hard carrage return in the text of the cell being returned. Also,
keep in mind if the cell with the VLOOKUP is a merged cell best fit will not
work. You might try
=CLEAN(VLOOKUP(A1,Table,3,False))
but its hard to say if that will help.

--
Thanks,
Shane Devenshire


"Bev-Roseland-NJ" wrote:

I'm using a drop down list, data validation and vlookup on a spreadsheet. All
is working well EXCEPT when the cell populates with the the verbiage from the
vlookup, the cell will not word wrap, shrink to fit, auto adjust or format as
I request. I need to size the cell according to the amount of text being
referenced . Do I need to do something special?

A formula can only return a value, not a format, so in using VLOOKUP
the value that is in the correspending cell of the sought item will be
returned, but Excel cannot bring the format that is applied to that
cell. You will have to apply a format to the cell with the formula in
it which best enables you to display the various returned items.

Hope this helps.

Pete

On Nov 3, 7:03*pm, Bev-Roseland-NJ
wrote:
Thank you for this. I researched this in my Excel Bible and tried it. It
didn't hurt anything, but did not help my auto-size situation either. Awesome
suggestion and may help someone else, thank you.



"ShaneDevenshire" wrote:
Hi,

Normally the cell with the return value from a VLOOKUP would word wrap or
best fit (not automatically, but manually) *If it is not, it is likely that
you have a hard carrage return in the text of the cell being returned. *Also,
keep in mind if the cell with the VLOOKUP is a merged cell best fit will not
work. *You might try
=CLEAN(VLOOKUP(A1,Table,3,False))
but its hard to say if that will help.

--
Thanks,
Shane Devenshire

"Bev-Roseland-NJ" wrote:

I'm using a drop down list, data validation and vlookup on a spreadsheet. All
is working well EXCEPT when the cell populates with the the verbiage from the
vlookup, the cell will not word wrap, shrink to fit, auto adjust or format as
I request. *I need to size the cell according to the amount of text being
referenced . Do I need to do something special?- Hide quoted text -

- Show quoted text -