Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Learn how to use VLOOKUP, HLOOKUP, INDEX and MATCH to look up values in Excel tables. See examples, tips and limitations of each function, and how to use the new XLOOKUP and XMATCH functions.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2024, Excel 2021, Excel 2019, Excel 2016
Sign in to SharePoint - Microsoft Support
Learn how to access SharePoint, a browser-based app for online collaboration and document management, through your web browser. Find out how to check your subscription, troubleshoot issues, and get training for SharePoint.
Applies To: SharePoint in Microsoft 365
Download and install or reinstall Office 2019, Office 2016, or Office ...
Find out how to download and install Microsoft 365 or Office 2019, 2016, or 2013 on your PC or Mac. Follow the steps to sign in, choose your language and bit version, and activate your product.
Applies To: Office 2019, Office 2016, Office 2016 for Mac, Office 2013
Use the System File Checker tool to repair missing or corrupted system ...
Learn how to scan and repair missing or corrupted system files in Windows using the System File Checker tool (sfc/scannow). Follow the steps to run the tool, view the scan results, and manually replace the corrupted files if needed.
XLOOKUP function - Microsoft Support
Learn how to use the XLOOKUP function to find things in a table or range by row, with examples and syntax. XLOOKUP can return the first match, the closest match, or a wildcard match, and can handle nested or reverse searches.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Redeem a gift card or code to your Microsoft account
Learn how to redeem a Microsoft gift card, Xbox download code or token, Office product key, or Windows activation code to your Microsoft account. Find troubleshooting tips and contact support if you need help.
Applies To: Microsoft account dashboard
Download and install apps - Microsoft Support
Learn how to download and install Microsoft 365 apps, like Word, Excel, and PowerPoint, on your PC or Mac. Follow the instructions in the browser and sign in with your Microsoft 365 account to activate the apps.
What's the difference between Microsoft 365 and Office 2021?
Microsoft 365 is a subscription service that offers the latest productivity tools, cloud storage, and support, while Office 2021 is a one-time purchase that does not include upgrades or updates. Compare the features, prices, and benefits of both options and find out which one suits your needs.
Applies To: Office 2024, Office 2024 for Mac, Office 2021, Office 2021 for Mac, Office 2019, Microsoft 365 for home, Office for business, Microsoft 365 admin
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Learn how to download and install or reinstall Microsoft 365 or Office 2021 on a PC or Mac. Find out the system requirements, product keys, activation steps, and troubleshooting tips.
Applies To: Office 2024, Office 2024 for Mac, Office 2021, Office 2021 for Mac, Office 2019, 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
How to check if your device meets Windows 11 system requirements after ...
Learn how to use the PC Health Check app to see if your device meets the system requirements for Windows 11 after changing hardware. Find out how to manually refresh the eligibility assessment and troubleshoot issues with the app.