πŸ’¬ QUERY and MATCH

Replied to

Ben, I am intrigued on your QUERY / MATCH combo. Have you written about adjusting the columns? I would love to see a full formula. I have long tried to make a formula that allows me to select which columns to include via a checkbox. However, I can never quite get it to work.

2 responses on “πŸ’¬ QUERY and MATCH”

  1. Hey Aaron, to do column matching try a formula like this:

    =QUERY({data},”select Col”&MATCH(“Customer”,headerRow,0)&”, Col”&MATCH(“Revenue”,headerRow,0),1)

    where Customer and Revenue are column headings.

    You can nest IF functions if you want to use checkboxes too.



Leave a Reply

Your email address will not be published. Required fields are marked *