Lots of past HN discussion... https://hn.algolia.com/?q=you+suck+at+excel
That video was before the introduction of xlookup, which I believe is now worth considering over index and match.