Forum Discussion
XLOOKUP
I asked the Bing chatbot your question. This is it's answer.
XLOOKUP is a function in Microsoft Excel that allows you to find things in a table or range by row. For example, you can use it to look up the price of an automotive part by the part number, or find an employee name based on their employee ID ¹. It is a modern replacement for the VLOOKUP function and is more flexible and versatile ⁴. Is there anything else you would like to know about XLOOKUP?
(1) XLOOKUP function - Microsoft Support. https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929
(2) Excel XLOOKUP function | Exceljet. https://exceljet.net/functions/xlookup-function Zugegriffen 11.5.2023.
(3) How to Use the XLOOKUP Function in Microsoft Excel - How-To Geek. https://www.howtogeek.com/439286/how-to-use-the-xlookup-function-in-microsoft-excel/
(4) Excel XLOOKUP Function: All You Need to Know (10 Examples). https://trumpexcel.com/xlookup-function/