How to extract multiple matched columns

Question

I can extract matched columns using the FILTER function in Google Sheets, but I need help making it work when there are multiple matches. For example, if the header row contains the same value in several columns (like "Sales" in 3 places), I want to return all those columns dynamically — not just the first one.

I have attached a Google Sheets for you reference.

Google Sheet

Questions should be self-contained on this site. Please edit your question and insert a table of sample data together with another table that shows your manually entered desired results. — doubleunary
– doubleunary, Commented Oct 24 at 19:11

doubleunary · Accepted Answer · 2025-10-24 19:10:06Z

2

Use filter() with a match() that lists the required column names, utilizing hstack(), like this:

=filter('Raw Data'!A2:P, 
  match('Raw Data'!A1:P1, 
    hstack("Applicant ID", "Applicant Name", G1), 
    0
  )
)

See filter(), match(), hstack() and your sample spreadsheet.

answered Oct 24 at 19:10

doubleunary

21.9k13 gold badges38 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to extract multiple matched columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related