Use a Lookup to Return Multiple Matches?

Julia Bennfors
Julia Bennfors ✭✭✭
edited 05/14/20 in Formulas and Functions

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))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!