need to specify the vertical "indent" for "autofit" on ROW 1

[wotgoesup]

I have a VLOOKUP that pulls text into a "wrapped" text cell. I want to specify a gap between the last line of text and the bottom border of these cells ( to space things out)
Horizontally I can use the indent, but is there a vertical equivalent?

 

[xlhelp]

You first need to make sure that wrap text is turned on for the cells, else you will get little squares.

Then you will need to modify your formula to
=vlookup(expression)&Char(10)

Member- AAAA Association Against Acronym Abusers