Data Validation

gberg

Board Regular
Joined
Jul 16, 2014
Messages
180
Office Version
  1. 365
Platform
  1. Windows
I'm trying to get a data validation list that will list 5 options based on the Item Value

The following example has "Item 1" and "Item 2" and the validation options for these items

I want to set data validation for cells B7 and B8 so that the options are per the list above

ABCDEF
1ItemOption 1Option 2Option 3Option 4Option 5
2Item 1aaabbbcccdddeee
3Item 2
111​
222​
333​
444​
555​
4
5
6ItemOption
7Item 1
8Item 2

Thanks

Greg
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
@gberg

Well It works for what you have initally posted. Folks in the forum can only work with the data (and its presentation) as the requestor provides.
Please post a mini excel worksheet using the xl2bb add in and if I can't solve it someone else wll have the data to make a complete solution.
 
Upvote 0
I'm trying a different approach, not sure if there is a way to make this work?

I will make a table that the headers or the items. There will be over 1,000 items. Each item will have up to 5 values

Item 1Item 2Item 3Item 4Item 5
MEAMLFBDLGALMEA
EALFEAEAEA
BoxCNTSFMLF
LFLF
PCE

I will have items listed and I want the data validation to list out the options from the above table

I used this formula in the data validation =INDIRECT("Table1[Item 1]"). This worked but only for "Item 1"

I would like to have the "Item 1" reference the cell with the Item Description, is there a way to do this?

1677699750072.png


Hope this makes sense and thanks for any help
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top