Replied to

Because hard-coded A, B, C etc. no longer refer to the same columns?

Yes, this is one weakness of QUERY.

Workaround is to use a MATCH function with column heading names to generate "Col1" refs e.g.

=QUERY({data}, "Select "&MATCH("Revenue",headerRow,0)...

— Ben Collins (@benlcollins) April 6, 2022

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.

The post 💬 QUERY and MATCH first appeared on Read Write Collect.Also on: Twitter