@jevans9838 7 ай бұрын
Thank for thanking the tie to show this on Google sheets. Also your voice is very easy to listen to. You are great 😊
@ProlificOaktree 7 ай бұрын
Thank you! 😊
@haneefahamed4615 11 ай бұрын
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 10 ай бұрын
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 10 ай бұрын
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.
Simplilearn
Рет қаралды 26