[Solved] Vlookup all the values matching the search term instead of just one.

by


With Google Sheets use Query:

=QUERY(A:A,"select A where A contains """ & B3 &"""")

enter image description here

Since you have the Excel tag use this formula for excel:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:INDEX(A:A,MATCH("ZZZ",A:A)))/(ISNUMBER(SEARCH($B$3,$A$2:INDEX(A:A,MATCH("ZZZ",A:A))))),ROW(1:1))),"")

Copy/drag it down sufficient for your needs.

enter image description here

5

solved Vlookup all the values matching the search term instead of just one.