Cascading drop-down lists—where choosing a category like "Fruit" narrows the next list to "Apple" or "Pear"—are a staple of high-level data entry in Excel. The old INDIRECT method works, but it's ...

This Google Sheets Advanced Tutorial explains IF, VLOOKUP, INDEX MATCH, and pivot tables, plus macros and Apps Script for ...