| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you validate listed information with comment?
I can validate a list, but some of the words on my validation list have
comments. When I choose one of the words that have a comment, the comment doesn't show at the location. |
|
#2
|
|||
|
|||
|
Instead of using comments, you could store the data in an adjacent cell.
Then, use a VLookup formula to return the matching data when a selection is made. There are instructions for VLookup in Excel's help, and he http://www.contextures.com/xlFunctions02.html Redd0g wrote: I can validate a list, but some of the words on my validation list have comments. When I choose one of the words that have a comment, the comment doesn't show at the location. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting information copied and pasted from the WEB to excel | Excel Discussion (Misc queries) | |||
| Sharing information between Access and Excel | Excel Discussion (Misc queries) | |||
| Duplicating Cell Information | Excel Worksheet Functions | |||
| Database Information | Excel Worksheet Functions | |||
| import excel information | Excel Discussion (Misc queries) | |||
Linear Mode
