• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

help per item for drop down list

mhguda

New Member
Hello,

I have laboriously programmed my conditional drop down lists, and now I find I want a help box to pop up for each item in all such lists (in total there are five drop down lists, there will be more in future when I develop this spreadsheet). The drop down lists are items in a number of different categories. This I have found out how to do. But I cannot find how to provide the help text I want for each item in the last drop down list. Can anyone help me out? The help I want need not be more than one line, providing some crucial identifying information about the item under consideration.
 
can you define "help box"? do you mean a text explaining each choice? if that's the case, you can use vlookup function, provided that you have the reference set up somewhere in the workbook.
 
Yes, I mean a text explaining each choice. How would the vlookup be worked? It's a bit vague at the moment. Also, the dropdown list source is actually the header line of a named table; the table is chosen from the first dropdown list. I'm also wondering where I would put the explaining text in the workbook in such a way that I could reference it easily with the vlookup.
 
you need to create a couple of helper columns


helper column

#1 name of each choice

#1 explanation of each choice


Next to the pull down menu use vlookup function.
 
Back
Top