Drop down list from index/match formula


Alberto Martinez

Good morning!

Is it possible to show a drop down list form a formula designed to index distinct dates in a range ?

By using this formula I get a list of all the days in the year when we did inventory, I however would like to know if its possible to use the formula directly in the data validation drop down option so I don't have to create a list using formula in another page;


Thank you!


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

Index/ Match 1
Index, Match?? 1
index and match 11
Index Match Functions 1
Match/ Index question 2
index/match help 1
Countif, index and match 2
Vlookup, Index or Match - Problem 2