https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546
@2019
The new XLOOKUP function has solutions for some of the biggest limitations of VLOOKUP. Plus, it also replaces HLOOKUP. For example, XLOOKUP can look to its left, defaults to an exact match, and allows you to specify a range of cells instead of a column number. VLOOKUP is not this easy to use or as versatile. We’ll show you how it all works.
https://www.howtogeek.com/439286/how-to-use-the-xlookup-function-in-microsoft-excel/
#lambda #xlookup #vlookup #hlookup #excel
origin - https://www.pipiscrew.com/?p=19433 lambda-turn-excel-formulas-into-custom-functions