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.
@@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.
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. 😔
@@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?
Get the free demo sheet here: www.gotsheet.xyz/c/multiple-dependent-dropdown-list
Hi, tks for the tutorial! Can we do it in more rows?
Yes, it gets more complicated as you continue to add, but you can repeat in the same way for additional fields.
@@EamonnCottrell thank you!
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?
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.
@@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.
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. 😔
@@polarbear1713 Can you share a copy with me to take a look at? my full name at gmail
@@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?