XLOOKUP: the modern replacement
Everything VLOOKUP does, but simpler and without the fragile column-number trick.
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.