Creating Excel Dropdowns using Data Validation and Indirect Function

[@cathyme3069]

Very helpful. Thanks a lot. Just by the way, how do you know these things 😊?

[@dataexplorer7435]

Lots of practice 😃

[@patrickmathias2591]

Nice work 👍

[@vishalsarate3834]

Thanks for the solution sir !

[@dataexplorer7435]

Happy to help

[@kasondemusonda4511]

Sir kindly avail the text you enter for Apple colour at Data validation under source

[@bluecollar3217]

Thank you so much. This was extremely helpful.

[@dataexplorer7435]

Awesome, glad it worked for you.

[@ceszdamaso5102]

What if dates?

[@varindermohan3935]

Thanks for help 🙏

[@dataexplorer7435]

No problem 👍

[@HerMagicWord323]

I get an error the source evulates erreor

[@dataexplorer7435]

I hope you were able to fix your error. If not, feel free to reply and I can try to help.

[@Franklin-pc3xd]

Pretty worthless

[@dataexplorer7435]

Why?