Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on. Learn more at the Excel Help Center: [ Ссылка ]
► Subscribe to Microsoft 365 on YouTube here: [ Ссылка ]
► Follow us on social:
LinkedIn: [ Ссылка ]
Twitter: [ Ссылка ]
Instagram: [ Ссылка ]
Facebook: [ Ссылка ]
► For more about Microsoft 365, visit [ Ссылка ]
#MicrosoftExcel #Microsoft365
How to use the XLOOKUP function in Microsoft Excel
Теги
xlookup vs vlookupexcel xlookupmicrosoft excelxlookup in excelxlookup explainedxlookup functionoffice 365MicrosoftOfficeOffice 365softwaremicrosoft 365microsoft excel tutorialmicrosoft excel for beginnersmicrosoft excel formulasmicrosoft officemicrosoft office tutorialhow to use microsoft excel for beginnersexcel help 2021microsoft excel 2021How to use the XLOOKUP function in Microsoft ExcelXLOOKUP function in Microsoft Excel