Is there an such a function?

C

CBZ

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP...have 3pm deadline but making progress almost there! 3
An AddIn for a custom function 3
Creating a Drop down list then linking another cell. 1
Is there such an Excel Function? 6
Looking for an excel function which can mirror opposite the data 3
auto populating a cell based on another cell for an invoice 3
Match - not sure how to use this function 3
How to check if a certain function is used 2

Top