I'm noob in spreadsheets so struggling with making dropdown list.

I'm using Google Sheets.

What I want to do is :

making dropdown from list

I can make INDIRECT at empty cell and make dropdown by list of range, but I have to do same job 1000+ times. so I want to use function in data validation.
But, as you guess, since list of items distinguishes items by comma, I cannot enter multiple arguments function. How can I solve this problem?

migrated from superuser.com Jun 4 '18 at 21:27

This question came from our site for computer enthusiasts and power users.

  • Could you show us some sample data, and what you wanna to add to Drop Down List ? – Rajesh S May 29 '18 at 3:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy