VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
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
Reset a forgotten Microsoft account password
Notes: If you know your password, but just want to change it, go to account.microsoft.com Security tab, and select Change my password. If you know your username and password but they have stopped working, read My username and password have stopped working.
Applies To:
Microsoft account dashboard
Getting started with the new Outlook for Windows
Not sure which version you're currently running, see What version of Outlook do I have? Classic Outlook on Windows. If your accounts are supported in the new Outlook for Windows, you'll see a toggle in the upper right of classic Outlook to Try the new Outlook.. Selecting this toggle will download the new app and let you switch to the preview.
Applies To:
New Outlook for Windows
Help with the Microsoft account recovery form
2. Get your information ready. Collect as much information as you can about any Microsoft services you may have used with this account. The more information you can include when filling out the form, the better the chance you’ll have of regaining access to your account.
Fix problems that block programs from being installed or removed
The Program Install and Uninstall troubleshooter helps you automatically repair issues when you're blocked from installing or removing programs.
Install Visio or access Visio for the web - Microsoft Support
Install Visio (Visio Plan 2 or Visio Professional) Below we describe how to install the desktop app that is included with Visio Plan 2, and non-subscription versions of Visio Professional or Visio Standard 2024, 2021, 2019, or 2016.. If you have Visio Plan 1 see the steps under the tab Visio for the web. Step 1: Associate Visio with your account
Applies To:
Visio Plan 2, Visio Professional 2024, Visio Standard 2024, Visio Professional 2021, Visio Standard 2021, Visio Professional 2019, Visio Standard 2019, Visio Professional 2016, Visio Standard 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
Fix OneDrive sync problems - Microsoft Support
Contact Support For help with your Microsoft account and subscriptions, visit Account & Billing Help. 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. Admins
Applies To:
OneDrive for Business 24, OneDrive for Business, 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, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint admin center, SharePoint in Microsoft 365 Small Business
How to earn Microsoft Rewards points - Microsoft Support
Open Rewards dashboard. To earn points by searching with Bing on your mobile device, set Bing as your default search engine, use the Bing app, or use the Microsoft Launcher for Android app.
Applies To:
Microsoft account dashboard
Using IF with AND, OR, and NOT functions in Excel
Examples. Following are examples of some common nested IF(AND()), IF(OR()) and IF(NOT()) statements in Excel. The AND and OR functions can support up to 255 individual conditions, but it’s not good practice to use more than a few because complex, nested formulas can get very difficult to build, test and maintain.
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 Web App, Excel for Windows Phone 10
Schedule an out of office status in Microsoft Teams
To clear your out of office status and turn off your automatic reply in Teams, return to the Out of Office screen, click the toggle next to Turn on automatic replies and select the Save button. Once you've scheduled an out of office status and message in Teams, you'll see automatic replies turned on in Outlook with the time range and message you set in Teams.
Applies To:
Microsoft Teams