Forum Discussion
Retrieving Full Rows For Any Cells Matching Search Query
Hi! I use Spreadsheets for pretty basic stuff but have been trying to get into more complex uses for my new job. Something I'm setting up is a database for customer calls we receive, cataloguing thei...
=INDEX(A$2:A$10,SMALL(IF($C$2:$C$10=$B$12,ROW($A$2:$A$10)),ROW(1:1))-1)
Is this what you want to do? As you work with Office365 you can as well use FILTER formula.