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.

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