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