I'm using a vertical lookup to pickup project titles. The project
numbers and titles are in adjacent columns and in ascending order by
project number. The titles are a phrase of two to four words. When
the vertical lookup executes it frequently only picks up the last word
or the title instead of the entire phrase in the cell. Can you help
me understand this?