I am unsure how to word this properly, but I hope this makes sense.
Here is an example sheet
https://docs.google.com/spreadsheets/d/1P91qqhClA8oO3-N9OGSxrFH-6lXxttZ3IN4bIGRGjHw/edit?usp=sharing
I am trying to get the column range returned in when the string in INPUT!B1 can be seen in DATABASE!A2:A into INPUT!C1:C3
Thanks so much!
Return a column range in which a string is in a cell
flutters
0
Viewed 22
1 Answers
You can use FILTER() function.
=FILTER(DATABASE!A:C,DATABASE!A:A=B1)
VLookup(), Index/Match(), QUERY() all these functions will work for you.
Related