Technical > Gsheets
Database Style Functions
- Query
- Filter
- Vlookup
- Index
- Match
- ArrayFormula
- Comparative Study of Database Style Functions
- Query vs Filter
- Vlookup vs Index vs Match
Knowledge Base
The links above provide limited information about a few of the most used functions for using a spreadsheet for database type applications. This link to the right goes to a shared gDrive directory / Knowledge Base where there are individual files for the functions listed above plus many more files that detail numerous use scenarios, notable issues, and nuances. Please note, the files are .js (javascript) files. The do not execute anything. I use a programming text editor to take/make notes and I name the files .js files out of habit. Think of these as text files and open in text editors. |