Data Validation and Comments

[bob3940]

I am using data validation to create a drop down list so that I can limit the entries that a user can make in a cell(b5). I have created a named range (valid_data) that contains all of the valid entries and have entered that as the SOURCE for the data validation. This is working out as expected.

I have made extensive comments for each cell in my named range. Is it possible to have the comments that I entered in my named range be used as the comments for the cell (b5) where the data validation is set up?

as an example: I created a list of dogs in my named range and assigned comments for each breed.

Cell Cell Data Comment
---- --------- ------------------------------------
M1 Collie Very smart, Aprox weight, blah, blah
M2 Mastiff Huge Dog very lazy lots of drool
M3 Poodle Poodles look funny when shaved

When the user gets to cell b5 he is is able to choose the breed of dog from a drop down list.

If the user chooses collie then I want the comments for cell b5 to match the comments for cell m1, if he chooses Mastiff then the comments for cell b5 should match the comments for cell m2, etc

 

[xlbo]

Have a look at the VLOOKUP formula

post back with what you have tried if you get stuck

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question

 

[KenWright]

In line with Geoff's reply, take a look at my VLOOKUP FAQ in the FAQ section:-

How does VLOOKUP work?? faq68-4743

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[bob3940]

I have used vlookup before but I don't see how this would help mein my situation.

1)In my example I am using data validation to limit their choice to a select list of items. How does vlookup limit them to a specific list of valid entries.

2)I want to change the cell comment, I don't see how to do that with vlookup.

Bob

 

[xlbo]

aaaaah - you mean the comments in the setup of the Data>Validation ??

That being the case, you can only do that via code.

I thought you just wanted to shoe the comments NEXT to the cell where the user had used the Data>Validation to select an item

Rgds, Geoff

"Errors have been made....DPlank will be blamed"

Please read FAQ222-2244 before you ask a question