INDEX/MATCH should work to get the first match (or you can use HLOOKUP with a wildcard too) but you need something more complex to get multiple matches......

If your list is in A1:Z1 then to build another horizontal list of only those values try this formula in A3 confirmed with CTRL+SHIFT+ENTER and copied across

=IFERROR(INDEX($A$1:$Z$1,SMALL(IF(RIGHT($A$1:$Z$1,2)="95",COLUMN($A$1:$Z$1)-COLUMN($A$1)+1),COLUMNS($A3:A3))),"")

If you want a vertical list then replace COLUMNS function at the end with ROWS and drag down like:

=IFERROR(INDEX($A$1:$Z$1,SMALL(IF(RIGHT($A$1:$Z$1,2)="95",COLUMN($A$1:$Z$1)-COLUMN($A$1)+1),

see attached example

regards, barry

multi-lookup.xlsx

If your list is in A1:Z1 then to build another horizontal list of only those values try this formula in A3 confirmed with CTRL+SHIFT+ENTER and copied across

=IFERROR(INDEX($A$1:$Z$1,S

If you want a vertical list then replace COLUMNS function at the end with ROWS and drag down like:

=IFERROR(INDEX($A$1:$Z$1,S

**ROWS(A$3:A3)**)),"")

see attached example

regards, barry

multi-lookup.xlsx