How do I create drop down list that show multiple different values in Excel?

Question

This is my goal:

When I click on a drop down list, it will give me options that I have listed on a separate "Data Validation" sheet.  Once I select an option, it shows something different than listed.  So, for example, when shown a list containing 'A', 'B', or 'C', if I select 'A', the selection turns into 'Apple'.  If this description is too confusing, I apologize.  I found a link that solves my problem partially here.

In my workbook, I have a cell that can contain one of three options, which are decided based on another initial drop down list.  These three options determine a set of codes that you may choose from in the lists below.  They are as follows:

• IO Waiver
  • AVH
  • AVF
  • ADS
  • ADF
• Level 1 Waiver
  • FVH
  • FVF
  • FDS
  • FDF
• Self Waiver
  • SVD
  • SVF
  • SDS
  • SDF

What I need is for these descriptions to appear in the drop down list as such (without changing the final, original code once selected):

• IO Waiver
  • Day (Working)
  • 15 Min. (Working)
  • Day (Off Clock)
  • 15 Min. (Off Clock)
• Level 1 Waiver
  • Day (Working)
  • 15 Min. (Working)
  • Day (Off Clock)
  • 15 Min. (Off Clock)
• Self Waiver
  • Day (Working)
  • 15 Min. (Working)
  • Day (Off Clock)
  • 15 Min. (Off Clock)

If anyone can help, I'd highly appreciate it.  Thank you

Answer 1

Sorry about that.

It seems I misunderstood your needs thus the reference to Debra's site.

I cannot help with your problem.

Gord

Answer 2

Have a look at Debra Dalgleish's pages on Dependent DV Lists

https://www.contextures.on.ca/xlDataVal02.html#adv

Gord

That link was unsafe.  I used google to find the site elsewhere: https://www.contextures.com/xlDataVal02.html

I reviewed what was written and, unless I overlooked it, none of this pertains to my issue.  I already have the drop down lists dependent of another.  Did you review the site I linked too?

Answer 3

Have a look at Debra Dalgleish's pages on Dependent DV Lists

https://www.contextures.on.ca/xlDataVal02.html#adv

Gord