XLOOKUP function - Microsoft Support
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.
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
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Microsoft 365 for business If your business subscription plan includes the desktop version of the Microsoft 365 apps you won't see an option to install it unless someone in your organization assigned a license to you.. Learn how to check this in What Microsoft 365 business product or license do I have? or if you're a Microsoft 365 admin responsible for assigning licenses to people in your ...
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Finding your BitLocker recovery key in Windows - Microsoft Support
Where can I find my BitLocker recovery key? BitLocker likely ensured that a recovery key was safely backed up prior to activating protection. There are several places that your recovery key may be, depending on the choice that was made when activating BitLocker:
Global Customer Service phone numbers - Microsoft Support
Country/Region. Country/Region code. Phone number. Language. Australia. N/A. 13 20 58. English. New Zealand. N/A +64. 0800 800 004 9 368 5680. English
Uninstall Office automatically - Microsoft Support
After you restart your computer, the uninstall tool automatically re-opens to complete the final step of the uninstall process. Follow the remaining prompts.
Fix problems with apps from Microsoft Store
See also. If you can't find Microsoft Store, see Trouble finding Microsoft Store in Windows 10. If you're having trouble launching Microsoft Store, see Microsoft Store doesn't launch. If you can launch the Microsoft Store but you are just having trouble finding or installing an app, see I can't find or install an app from Microsoft Store. Need more help?
Getting the most out of your PC backup - Microsoft Support
When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier.
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Set up your Microsoft 365 sign-in for multi-factor authentication
By setting up MFA, you add an extra layer of security to your Microsoft 365 account sign-in. For example, you first enter your password and, when prompted, you also type a dynamically generated verification code provided by an authenticator app or sent to your phone.
Applies To: Office for business, Microsoft 365 admin
Find where your browser is saving downloads - Microsoft Support
To see where your browser is saving downloads, look in your browser's settings. For example, in the new Microsoft Edge , select Settings and more > Settings > Downloads .The file path for your downloaded files (for example, C:\Users\[your name]\Downloads) is listed under Location.. In Microsoft Edge Legacy , select Settings and more > Settings .