Table for a List in Data Validation?

[DavidB90]

Hi All,

I'm sorry for my lack of experience once again, but here I am.

I'm trying to see if there is a way to have multiple table choices in a dropdown just like I can use Data Validation to create a dropdown for items in a single cell.

Here is my situation....I have 4 geographical areas our business covers and each area contains a different cost for items. I want to use the same spreadsheet to layout the cost, but have the dropdown of prices change based on the area. Therefore instead of changing the price of the column of items individually I would like to have the whole column change by selecting the area we are working in.

Thank you all once again!

 

[JamesCanale]

I think this might be along the lines of what you need.

MrExcelPlayground20.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Region	Southeast		Midwest	Northeast	Southeast	West	North		Selected Price
2	Price pick	5		5	6	3	5	2		3
3				6	9	5	5	2		5
4				5	10	6	5	3		6
5				10	15	10	6	2		10
Sheet17

Cell Formulas
Range	Formula
J2:J5	J2	=INDEX(D2:H5,,MATCH(B1,D1:H1,0))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B1	List	=$D$1:$H$1
B2	List	=$J$2#

 

[awoohaw]

Take a look at this video by Leila Gharani.
The second half discusses using tables to create dynamic drop down lists: