assigning numerical values to a drop down list

**ashtreyy** · 05-23-2016, 10:25 AM

hi

l'm new here and l hope you can help me....

l have some survey results that l want to enter in a spreadsheet. l have created two (2) drop down list, one named RESULTS containing these values; positive,negative,no sample and invalid. the other drop down list named TYPES contains these values Malaria, TB, Schisto and AIDS. l want to assign values to the drop down list e.g positive = 1, Negative = 0, no sample= 2, invalid = 3.....malaria=1, tb=2, schisto=3, aids=4. l want the drop down list to reflect the numerical value rather than the words in the same cell of the drop down list. also when l select 1 (for positive) the drop down list (TYPES) on the next cell should give me the option to choose from 1-4 (the numerical values of the diseases), however if l choose 0,2 or 3 on the drop down list RESULTS l want the drop down list TYPE not to respond.
l hope this is possible

thank you in advance

**Richard Buttrey** · 05-23-2016, 10:44 AM

Hi,

Would you upload the workbook and separately note a few examples of what you expect to see in response to various choices

**Ochimus** · 05-23-2016, 11:34 AM

ashtreyy,

Try the attached.

"Results" DropList in D8 contains the four numbers for the various options.

If you select "1" (Positive), then "Type" DropList in F8 will offer you the four numbers matching different diseases.
If you select anything else, the "Type" DropList will not offer you any choice.

As ever, the previous selection in "Type" will still show. If you want the DropBoxc to clear, you will need a small macro linked to the sheet that will turn the Type blank everytime you click on the RESULT DropBox.

Hope that helps

Ochimus