Replace confusing cell references with global constants, local variables, and reusable custom functions.
The difference between struggling with Excel and working smoothly is often just a few habits.
This Google Sheets Advanced Tutorial explains IF, VLOOKUP, INDEX MATCH, and pivot tables, plus macros and Apps Script for ...