Multiple dependent dropdown lists in Google Sheets with INDIRECT

Поделиться
HTML-код
  • Опубликовано: 28 ноя 2024

Комментарии • 14

  • @EamonnCottrell
    @EamonnCottrell  Месяц назад

    Get the free demo sheet here: www.gotsheet.xyz/c/multiple-dependent-dropdown-list

  • @stefania8715
    @stefania8715 Месяц назад

    Hi, tks for the tutorial! Can we do it in more rows?

    • @EamonnCottrell
      @EamonnCottrell  Месяц назад +1

      Yes, it gets more complicated as you continue to add, but you can repeat in the same way for additional fields.

    • @stefania8715
      @stefania8715 Месяц назад

      ​@@EamonnCottrell thank you!

  • @polarbear1713
    @polarbear1713 Месяц назад +1

    I am just gonna ask random advice for Google Sheets on mobile.
    Do you know if any way to do a filter and get the row number of the returned values?

    • @EamonnCottrell
      @EamonnCottrell  Месяц назад +1

      You could use Match to find the position of an item in a range. You'd want to set the last optional parameter to 0 for an exact match. =MATCH(G1,C1:C,0) will look for whatever you type into G1 throughout the C1:C range and return the first exact match.

    • @polarbear1713
      @polarbear1713 Месяц назад +1

      @@EamonnCottrell Thanks for responding.
      I was hoping to have the row number of each instance and not just the first one in the list because it is an unsorted list.
      The only way I can think of to do this is a lot of work. Basically, use MATCH on the first returned filtered row, then use MATCH, INDIRECT, and the returned row value to start looking after the returned row value (always the same column).
      Is there anything easier to do because another issue is I don't know how many items will be returned with the filter, although I could copy and paste the solution all the way down my search form, if necessary.

    • @polarbear1713
      @polarbear1713 Месяц назад +1

      And actually, I don't think that will work like I want it to. MATCH doesn't seem to be giving me the right info. In my sheet, it should give me back 40 but it's giving me 142, which doesn't even match the search. 😔

    • @EamonnCottrell
      @EamonnCottrell  Месяц назад

      @@polarbear1713 Can you share a copy with me to take a look at? my full name at gmail

    • @EamonnCottrell
      @EamonnCottrell  Месяц назад

      @@polarbear1713 What if you simply added a column to number everything in your dataset from 1 to whatever it goes up to and then returned that field as part of the result using either a filter or query?