Use a Lookup to Return Multiple Matches?

Julia Bennfors

What replaces/is equal to the "row function"? I am trying to look up data with various criteria and array those multiple matches into separate cells? Using the article and formula below, I tested it in excel with my data and it worked.....I just cant translate here. Can you use the example below as the demo when showing formulas for SS. Please & Thanks!

=INDEX($B$3:$B$37,SMALL(IF(D$2=$A$3:$A$37,ROW($B$3:$B$37)-2,""), ROW()-2))

https://www.smartsheet.com/advanced-vlookup-multiple-criteria

L_123

=index(collect($A:$A,$B:$B,@cell = D$2),1)

Give that a try. Increase the 1 to reflect the next value for each row.

L_123

=index(collect($A:$A,$B:$B,@cell = D$2),1)

Give that a try. Increase the 1 to reflect the next value for each row.

Julia Bennfors

Thank you so much! This worked!