Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Microsoft account security info & verification codes
For technical support, go to Contact Microsoft Support, enter your problem and select Get Help. If you still need help, select Contact Support to be routed to the best support option. Learn how to manage your Microsoft account security info and troubleshoot verification code issues.
Applies To: Microsoft account dashboard
How to earn Microsoft Rewards points - Microsoft Support
How to earn Microsoft Rewards points. It’s easy to rack up Microsoft Rewards points and earn your way toward great rewards like gift cards, movies, games, nonprofit donations, and more. Stay signed in with your Microsoft account and you'll earn points for doing the things you already do.
Applies To: Microsoft account dashboard
Sign in to SharePoint - Microsoft Support
Sign in to SharePoint. SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.
Applies To: SharePoint in Microsoft 365
Track my Microsoft Rewards orders - Microsoft Support
If you want to track your Microsoft Rewards order after you redeem an award, sign in to the Rewards page with your Microsoft account, select Redeem and then select Order history. On the Order history page, find your order and then look under Status. Open Rewards dashboard.
Windows help and learning
Find the information you need to build, run, and grow your small business with Microsoft 365. Find help and how-to articles for Windows operating systems. Get support for Windows and learn about installation, updates, privacy, security and more.
Combining Microsoft accounts - Microsoft Support
If you have a Microsoft 365 Family subscription, you can share your subscription and its benefits with up to 5 other people. Accounts you share with are not linked, and emails, OneDrive files & photos remain private (unless you share files or photos ). Join a Family group.
Applies To: Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 for home, Outlook.com, Microsoft 365 for Mac, Microsoft 365 for Windows, Microsoft account dashboard, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Combine text from two or more cells into one cell
Combine data using the CONCAT function. Select the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
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 2019 for Mac, Excel 2016, Excel Mobile
Play a CD or DVD in Windows Media Player - Microsoft Support
In Windows Media Player, you can play audio CDs, data CDs, and data DVDs that contain music or video files (also known as media CDs). You can also play video CDs (VCDs), which are similar to DVDs, although the video quality isn't as high.
How to sign in to Hotmail - Microsoft Support
Your Hotmail or Outlook.com password is the same as your Microsoft Account password. If you can you sign in but are having problems with Outlook.com, check the service status. If the status isn't green, wait until the service is running normally and try again.
Applies To: Outlook.com