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 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, 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
Turn off, disable, or uninstall OneDrive - Microsoft Support
OneDrive is built in to some versions of Windows and can't be uninstalled. But you can hide it and stop the sync process, so it stays hidden. To do this, turn off all the OneDrive settings and remove the OneDrive folder from File Explorer.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Office for 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, SharePoint operated by 21Vianet
Activate Windows - Microsoft Support
To check activation status in Windows 11, select the Start button, and then select Settings > System and then select Activation .. Your activation status will be listed next to Activation.. Check activation status in Settings. You'll see one of these activation status messages on the Activation page:
Free up drive space in Windows - Microsoft Support
Note: If it’s been fewer than 10 days since you upgraded to Windows 10, your previous version of Windows will be listed as a system file you can delete.If you need to free up drive space, you can delete it, but keep in mind that you'll be deleting your Windows.old folder, which contains files that give you the option to go back to your previous version of Windows.
Download Microsoft Authenticator - Microsoft Support
To install Authenticator on your iOS device. Scan the QR code. or download and install Authenticator from the Apple app store. Get the app
Manage user accounts in Windows - Microsoft Support
Important: you should limit the number of administrators on your Windows device because administrators have complete control over the system.Administrators can change settings, install software, and access all files. If too many people have this level of access, it could lead to security risks like malware installation or unwanted changes to your system.
Internet Explorer mode in Microsoft Edge - Microsoft Support
Internet Explorer 11 support ended on June 15, 2022. If any site you visit needs Internet Explorer 11, you can open it with Internet Explorer mode in Microsoft Edge.
Fix Ethernet connection problems in Windows - Microsoft Support
On your home router. Try these things first to help you fix or narrow down the connection problem. Check the Ethernet cable and connection.Make sure the Ethernet cable is securely plugged into the Ethernet port on both your router and Windows 11 PC.
Use the Office offline installer - Microsoft Support
Step 2. Install Office. Select the Microsoft 365 folder from the virtual drive and then double-click either the Setup32.exe to install the 32-bit version of Microsoft 365, or Setup64.exe to install the 64-bit version to begin the offline installation. If you're not sure which version is right for you, see Choose the 64-bit or 32-bit version of Office. ...
Applies To: Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin