| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup - return exact phrase | Excel Discussion (Misc queries) | |||
| Conditional Vlookup - Cherry picking information from the table ar | Excel Discussion (Misc queries) | |||
| VLookup function to search an entire workbook | Excel Worksheet Functions | |||
| Vlookup through entire column | Excel Worksheet Functions | |||
| carrying entire row to another sheet using vlookup | Excel Discussion (Misc queries) | |||
Linear Mode
