Multi cell for drop down list more than one column

Hi All

Hope someone can help, I am creating an excel questionnaire with drop down answers, these are graded 1-10 with the next cell being the discriptive text, needs to be as sheet 2. I am trying to create a drop down list for Cells A1 and B1 together from a list (table) on sheet 2 but can only get it to show 1 column at a time. Attached a spreadsheet showing what i am trying to do, sheet1 cell B1 press dropdown arrow and it dispays both column from list on sheet 2, on selecting it populates cells A1 and B1 on sheet 1. I am keeping the grade seperate to the comments as the comments will change and there will be 20 questions with varied responses for each grade, eg next question may be how often do you....... and the drop down list would be 1 never - 10 always etc. Also I need to both the number and comments in the droplist view when selecting. I know excel can do this but got completely lost on combolist, surely if 2 cells are selected excel can pick from a droplist with 2 cells in the list.

Regards

Graham

Not entirely sure what you are asking, but if you want the dropdown list to show something like "1 - Very Bad", "2 - Quite Bad", etc... then you can do this:

On Sheet 2, in cell C1, add this formula, then fill down to the bottom of your list: =A1&" - "&B1
Then, highlight that new range, and define a new name for it in the Name Manager, such as: ComboList

Then go back to sheet 1, highlight the range you currently have Data Validation in and go to the DV manager. The current source is =commentlist1.
Change that to the newly created named range =ComboList.

If that is not what you want, let us know.

- Moo

Is this what you want?
2 cells drop down list.xlsTEST.xlsm

Hi Legend , thanks for the response the VLook up is close, however when i click for the dropdown list in column A it only shows the grade eg 1-10 and not both the grade and relevant comments together, sounds petty but the comments on my example are very simple and the questionnaire would have much more discriptive comments, so the view of the comments would be the decision maker along with the grade.

so does it need to only show the grade once selected or can it show the whole thing?
Eg, can it show "1 = Very Good", or only "1"...?

it needs to show the whole thing but populate cells in column A with the grade and column B with comments, need to keep the number grade seperate as this will not only be totalled as a percentage but each question will also be weighted eg overall feeling of the service (question 1) good bad etc may count for 50% of the total customer satifaction where as how often do you ... may only count as 10% of the weighting

Overall feeling maximum points 10 x 5 (50%) = 50
How often maximum points 10 x1 (10%) = 10

Points would be out of 100 to then grade customer satisfaction

i dont know that this is possible...
do you care if the is three columns?
Column 1 = DataValidationList
Column 2 = Score
Column 3 = Comment?
If not...2 cells drop down list.xlsTEST2.xlsm

Thanks Legend, Moo & FDibbins, I think I will have to have a joint cell showing grade and comments as per Moo suggestion that then populates via Vlookup the grade column so should look like this

grade comment
1 1 - Very Bad

that way i can still use the number in the Grade column but have view of both grade and comment in droplist

Glad I could help. Thanks for the rep.

Thanks be from me too