NEW! XLOOKUP
This is so cool. Mind Blown. XLOOKUP is conceptually similar to the other LOOKUP Functions, eXcept it doesn’t have the limitations of VLOOKUP and is easier to use! Use it in place of VLOOKUP or HLOOKUP. Default match is exact not approximate Match options are greater File_not_found options Searches a range for a match and…