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.
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.
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
Thank for thanking the tie to show this on Google sheets. Also your voice is very easy to listen to. You are great 😊
Thank you! 😊
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.
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.
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