Is there an such a function?
 

Just wondering is there such a function that would allow me to present
separate drop down pick lists dependent upon reference cell content.

ie. if cell b2="queue" then list for pick cells A1:A10 or if cell
b2="queue1" then list alternative list for pick b1:b10?

As always I appreciate the help or ref. to another function that may assist
me?

Is there an such a function?
 

See Dependent Lists at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal02.html


Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"CBZ" wrote in message ...
Just wondering is there such a function that would allow me to present
separate drop down pick lists dependent upon reference cell content.

ie. if cell b2="queue" then list for pick cells A1:A10 or if cell
b2="queue1" then list alternative list for pick b1:b10?

As always I appreciate the help or ref. to another function that may assist
me?

Is there an such a function?
 

This was perfect...thanks so much.

"Ron Coderre" wrote:

See Dependent Lists at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal02.html


Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"CBZ" wrote in message ...
Just wondering is there such a function that would allow me to present
separate drop down pick lists dependent upon reference cell content.

ie. if cell b2="queue" then list for pick cells A1:A10 or if cell
b2="queue1" then list alternative list for pick b1:b10?

As always I appreciate the help or ref. to another function that may assist
me?