How to Use Dropdowns in Google Sheets

Learn how dropdowns function. You can use them to control user inputs and validate data as it is entered. See how to style the dropdowns and even learn how to implement dependent dropdowns.
XLOOKUP webpage - sheetshelp.com/xlookup/
XLOOKUP Video - • How to use XLOOKUP in ...
Timestamps:
0:00 Background and setup
0:58 Insert basic dropdowns
2:49 Customizing appearance and behavior
8:05 Dropdowns from a range
9:28 Multi-Level Dependent Dropdowns
13:33 Next video - Google Forms
#google #spreadsheet #dropdown

[@jevans9838]

Thank for thanking the tie to show this on Google sheets. Also your voice is very easy to listen to. You are great 😊

[@ProlificOaktree]

Thank you! 😊

[@haneefahamed4615]

I followed the video and tried it with two sheets. But Xlookup only works for the B9 cell. when I change the B10 cell to cold sandwich, it only gives the "items" of B9(Salad) to select. Is there a way to make it work for all the cells? or I have to make xlookup for every cell with search_key as B9,B10,B11 and so on, individually? please let me know and thank you for the video.

[@ProlificOaktree]

I am thinking of some sort of sandwich joke here, but it's just not coming to me. I think what you're running into is too hard to diagnose without looking at the shared sheet.

[@haneefahamed4615]

I am sorry, my explanation of the issue is quite bad and the issue was a mistake of mine. My Second-dropdown ( items ) wasn't working properly, because it was in, fixed values with the "$". So i took it off and it works.
Thank you very much for the reply.@@ProlificOaktree

[@johncipolla8335]

Great video. How can I do A sort criteria based off of. a drop down list. im still watching the video

[@ProlificOaktree]

I’d have to be looking at your spreadsheet to answer that one. Good luck!

[@markloughtonUK]

I ended up using a separate sheet and then called all the data in using the UNIQUE and SORT formulas then I used that organised list as the drop-down list.