Learn how the DGET function in Google Sheets returns one value that meets several conditions, with a worked Name and Month example, four variations and fixes for #VALUE! and #NUM!.
Tag: Google Sheets
FILTER and ISBLANK Function in Google Sheets (With Example)
Use FILTER with NOT(ISBLANK()) in Google Sheets to return only the rows that have a value, with a worked example, five variations, common errors and a free practice file.
Income Expense Dashboard in Google Sheets
A ready-made Income Expense Dashboard in Google Sheets with total income and expense cards, an expense percentage doughnut and category charts. See what each tab does and how to load your own data.
Packing Checklist Template in Google Sheets (Free Copy)
A free Packing Checklist Template in Google Sheets with 45 sample items, packed and priority drop-downs, luggage locations and three summary charts. See every column, simple progress formulas and how to adapt it for your trip.
Birthday and Anniversary Tracker in Google Sheets with Search Feature
A Birthday and Anniversary Tracker in Google Sheets that counts the days left to every occasion and lists what is coming up in the next 7, 30 or 90 days. See each sheet, the Remaining Days formula and how to set it up.
INDEX with Double MATCH in Google Sheets (Two-Way Lookup)
Use INDEX with two MATCH functions in Google Sheets to look up any employee by ID and any field by its header, with a worked call-centre example and a free practice file.
Sparklines in Google Sheets: Line, Column and Win/Loss Examples
Learn the SPARKLINE function in Google Sheets with three worked examples: a line sparkline for daily sales, a column sparkline for quarterly margin and a win/loss sparkline for attendance.
3D Doughnut Chart in Google Sheets: Step-by-Step Guide
Build a dynamic 3D doughnut chart in Google Sheets from a pie chart, two data cells and one helper formula, with the KPI value shown in the centre of the ring.
Gauge Chart in Google Sheets: Step-by-Step Guide (Service Level Example)
Build a gauge chart in Google Sheets from just a label and a value: insert the Gauge chart, set the scale and red/orange/green bands, and drive it with a live Service Level formula. Free practice file included.
6 VLOOKUP Tricks in Google Sheets (With Real Examples)
Six practical VLOOKUP tricks in Google Sheets – normal lookup, VLOOKUP with COLUMN, VLOOKUP with MATCH, double VLOOKUP, IFERROR handling and age buckets – with a free practice file and checked results.