How To Use Column Names in the QUERY Function (Google Sheets Tutorial)

[@trumanchau7884]

I have improvised Ben's approach to simplify the query formula entry by creating two helper rows with the header names and the "Col#" reference derived from the XMATCH equation. Instead of calling out individual headernames in the select statement, the formula simplifies to: =query(RangeName,"select "&TEXTJOIN(", ",TRUE,A2:F2)&"") where A2:F2 stores the "Col#" results.

[@trumanchau7884]

Ben Collins, you are amazing! You have provided the most elegant, simplest, and easy to implement workaround to one of the epic fails in gSheets. I hope that you can influence Google Product team to address this obvious blunder where one cannot simply query using header names.

[@DrewK1979]

Great tutorial, this helped simplify a rostering system I built for a non-profit - well done!

[@Aaron-3das]

EXACTLY what I needed! Thank you!

[@johnagusta6149]

Thanks Ben, a pretty simple solution. As you are aware, I developed a solution as well and used Named Functions to simplify the implementation.

[@benlcollins]

Yes, I remember. Using named functions is a smart idea anytime you reuse complex functions over and over. Happy New Year!

[@KevnReid]

I would love to have access to this Named Function! Do you mind sharing the code or point me to where you have it?

[@AndrewMalcolmson]

@@KevnReid Try "=concat("Col",xmatch(header_name,headers))" where header_name is the function's header name argument (e.g. "Total Sales").

[@mircopolo]

Wow you fixed what Google Sheets were missing on QUERY :D

[@brianandrewsmusic]

Thanks Ben! Something tells me this will become my favorite CZcams channel...

[@benlcollins]

Thanks! Appreciate your support 🙏

[@rohitbhandari6382]

Nice sr thanks

[@rohitbhandari6382]

I am trying to grab data from different work sheet the xmatch isn't working. Its saying the range name is unknown.

[@mooripo]

aamazing thanks

[@ganeshshelkar4333]

Woww best video sir🎉🎉

[@monologuesofaconsultant]

Very interesting application. Thank you.

[@benlcollins]

Thanks. You're welcome.

[@TheDervMan]

Nice 👍🏻

[@asadiqbal1058]

header keyword is not working

[@ibrahimosama9300]

i just protect the headers 😅