Data Validation

[gberg]

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

	A	B	C	D	E	F
1	Item	Option 1	Option 2	Option 3	Option 4	Option 5
2	Item 1	aaa	bbb	ccc	ddd	eee
3	Item 2	111​	222​	333​	444​	555​
4
5
6	Item	Option
7	Item 1
8	Item 2

Thanks

Greg

 

[Fluff]

I was trying to get the table references in

You cannot use structured references in data validation.

 

[awoohaw]

@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.

 

[gberg]

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 1	Item 2	Item 3	Item 4	Item 5
MEA	MLF	BDL	GAL	MEA
EA	LF	EA	EA	EA
Box	CNT	SF		MLF
		LF		LF
				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?

Hope this makes sense and thanks for any help