INDEX + MATCH for older Excel
The classic combination that still works everywhere, including Excel 2016.
This lesson is part of Pro
Module 1 of every course is free forever. Pro unlocks every other module of every course, removes ads, and adds workbooks and certificates.