A modern lookup function that searches any column and returns a match — exact by default, and able to look left or right.
Try it with AIXLOOKUP replaces VLOOKUP, HLOOKUP, and INDEX/MATCH with one function. It takes a lookup value, a lookup array, and a return array, defaults to exact match, and has a built-in if-not-found argument.
=XLOOKUP(lookup_value, lookup_array, return_array, "Not found")Yes for most cases — it can look left, defaults to exact match, and handles not-found cleanly. It requires Microsoft 365.