I'm using the vertical lookup function to fill in cells in a spreadsheet and
for whatever reason part of the text gets cut off at the end. There are a
good 20+ characters left off. When I open both files (the looker upper and
the looker frommer) all of the text is filled in.

Why does this happen, and what may be a solution?