Premium Only Content

Google Sheets - QueryByName Named Function
Use column names in your QUERY()
Target Experience Level: Intermediate
Topic Level: Intermediate to Advanced
Benefits
Makes using QUERY() more intuitive
If columns change your function will continue to work
References
https://www.benlcollins.com/
A free site with plenty of free Google Sheets and app script tips and guides. Sign up and get weekly tips delivered to your inbox.
Articles from Ben Collins for Named Functions:
SCAN Function in Google Sheets - LAMDA Helper Function
https://www.benlcollins.com/spreadsheets/scan-function/
Lambda Functions 10-Day Challenge
https://courses.benlcollins.com/p/lambdafunctions
QUERY & MYSELECT functions, Select by Column Names (Headers, Labels) - Google Sheets
https://www.youtube.com/watch?v=clq7WlC2whk&list=PLn5v4CFyfaY_gjJ1vl-1rBrV6GQL3lq87&index=3&t=43s
Google Resources
SCAN Function
https://support.google.com/docs/answer/12569094?hl=en
Working Model Showing How to use QueryByName, Named Functions Included (make your own copies if you like)
QueryByName
https://docs.google.com/spreadsheets/d/11AtsQslRDJ6E5TJctFONDyFkQt6NsIYjyrcQLQH2eYs/edit?usp=sharing
Youtube Links
Named Function Tutorial (includes link to Named Function Library)
https://youtu.be/sqdDEms0Ct4
Rumble Links
Named Function Tutorial (includes link to Named Function Library)
https://rumble.com/v25qm9k-introduction-to-google-sheets-named-functions.html
-
1:22:57
Game On!
13 hours ago $1.32 earnedHere's Why The Eagles Are The Betting Favorites To REPEAT As Super Bowl CHAMPS!
30.6K -
28:25
The Rad Factory
12 hours ago $1.61 earnedFULL TOUR of My $10k Car & Bike Collection
46.7K5 -
13:24
James Klüg
1 day agoWhy Are So Many Democrats Not Proud To Be American?
7.1K5 -
1:23:26
Dad Dojo Podcast
1 day ago $0.91 earnedEP39: Josh Fighting Nate Diaz?
10.9K -
53:00
The Dr. Ardis Show
1 day ago $6.27 earnedThe Dr. Ardis Show | Is There An Answer to Lyme Disease w/Kerri Simpson | Episode 07.09.2025
18.4K10 -
BEK TV
1 day agoTrent Loos in the Morning 7/10/2025
12.8K1 -
8:25
The Car Guy Online
20 hours ago $2.54 earnedRAMs Latest BLUNDER & The PLASTIFICATION of Trucks. RAM 1500, 2500 & 3500
50.4K12 -
15:47
Preston Stewart
22 hours ago $1.41 earnedDeadly Trap in Gaza
21.1K20 -
14:09
BlackBeltBarrister
23 hours ago $1.67 earnedThey Fell for the TRAP!
22.6K6 -
16:08
Professor Gerdes Explains 🇺🇦
15 hours agoTrump's Tough New Putin Talk: Just Words or Real Action Coming?
17.8K6