The bigger your spreadsheet, the more you need INDEX and MATCH functions, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

Match One is a very simple CandyCrush-like Match 3 example, except it's Match One. Watch the talk from Unite Europe 2015 to get an in-depth tutorial. Match One shows systems list in GameController how ...