Define name based on non-sequential cells

[trigger467]

I am trying to define a name that is based on two non-sequential cells.

I want to use a drop down list based on these two cells but the data valadation will not allow it so I was hoping I could define a name instead.

Is there another way to do this.

example: I would like a drop down list that contains the values of cells E5 and E9 only.

Thanks for the help.

trigger467

 

[stanleydgromjr]

trigger467,

Excel Workbook
	A	B	C	D	E	F
1	trigger
2	467					trigger
3						467
4
5					trigger
6
7
8
9					467
Sheet1

The data validation of the cells A1, and A2, is taken from range F1:F3.

Highlight cells A1, A2, and click on Data, Validation, in the "Allow:" drop down, pick "List",
in the "Source:" box, enter
=$F$1:$F$3


Have a great day,
Stan

 

[trigger467]

Thanks!

That is a little more labor intensive than I was looking for in my workbook, but I can easilly implement it with a little more time.

Thanks again.