ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VLookup Not Picking Up Entire Phrase (https://www.excelbanter.com/excel-programming/310888-vlookup-not-picking-up-entire-phrase.html)

TerryM

VLookup Not Picking Up Entire Phrase
 
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?

Tom Ogilvy

VLookup Not Picking Up Entire Phrase
 
Never seen this occur. Sure you don't have justification set so it appears
that way?

--
Regards,
Tom Ogilvy

"TerryM" wrote in message
m...
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?





All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com