XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a 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.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Deprecation of Microsoft Support Diagnostic Tool (MSDT) and MSDT ...
Devices running Windows 11 version 22H2 and older. If you're running Windows 11 version 22H2 and older, Windows 10, Windows 8.1, Windows 7 or any other earlier OS version, your device will not be affected by the MSDT Troubleshooter retirement.
Combine text and numbers - Microsoft Support
Examples. See various examples in the figure below. Look closely at the use of the TEXT function in the second example in the figure. When you join a number to a string of text by using the concatenation operator, use the TEXT function to control the way the number is shown. The formula uses the underlying value from the referenced cell (.4 in this example) — not the formatted value you see ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Add or remove an email alias in Outlook.com - Microsoft Support
To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.
Applies To: Outlook.com
Find and open File Explorer - Microsoft Support
File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:
How to update Windows Security - Microsoft Support
Windows Update downloads updates for Windows Security automatically to help keep your device safe and protect it from attacks.
Stop Microsoft Edge from starting automatically
If you don't want Microsoft Edge to start when you sign in to Windows, you can change this in Windows Settings. 1. Go to Start > Settings .. 2. Select Accounts > Sign-in options.. 3. Turn off Automatically save my restartable apps and restart them when I sign in.
Find and open File Explorer - Microsoft Support
File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:
Compare and merge two versions of a document - Microsoft Support
In the Revised document list, browse to the other version of the document, and then select OK.. Changes from the revised copy are merged into a new copy that is based on the original version of the document. The original copy remains untouched.
Applies To: Word 2019 for Mac
Get started with SharePoint - Microsoft Support
See Share SharePoint files or folders in Microsoft 365 or Video: Share documents in SharePoint Server.. Share sites. If you have site owner permissions, select >Site permissions, select Add members, and then select Add members to group or Share site only.Fore more information, see Share a site.. Create a team site. If you're using Microsoft 365, you can create a site from the SharePoint start ...
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, SharePoint Foundation 2013, SharePoint in Microsoft 365 Small Business