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.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use Microsoft Teams for work or school in Windows 11
If you are planning to use Teams free or if you were a guest in an org, you can connect and collaborate by downloading and installing another version of Microsoft Teams (work or school) and signing in with your Microsoft account or the guest account where the invite was sent to.
Applies To:
Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
Give your PC a Fresh Start - Microsoft Support
To reset your PC, go to Start > Settings > System > Recovery .Next to Reset this PC , select Reset PC.Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No.. Open Recovery settings
Shut down, sleep, or hibernate your PC - Microsoft Support
Turn your PC off completely. To shut down, select Start and then select Power > Shut down.. Sleep. Sleep uses very little power, your PC starts up faster, and you’re instantly back to where you left off.
Comment se connecter et se déconnecter d’Outlook.com
Pour obtenir de l’aide dans Outlook.com, cliquez ici ou sélectionnez Aide dans la barre de menus et entrez votre requête. Si l'auto-assistance ne résout pas votre problème, faites défiler la page jusqu'à la rubrique Avez-vous toujours besoin d'aide ? et sélectionnez Oui.. Pour nous contacter dans Outlook.com, vous devez vous connecter.
Applies To:
Outlook.com
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
Activate Office - Microsoft Support
If this screen appears, Microsoft 365 is installed as a one-year subscription or one-time purchase. A digital product key is transmitted to your PC, so you won't need or receive a printed product key.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Microsoft 365 admin, Project for Office 365
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
Update drivers manually in Windows - Microsoft Support
Note: The best and safest way to get driver updates in Windows is always through Windows Update.If you are having problems with Windows Update, you might see if any of the links at Update Windows can help you out first.
Import photos and videos from an iPhone to PC - Microsoft Support
Transfer photos from an iPhone to your PC. First, connect your iPhone to a PC with a USB cable that can transfer files. Turn your phone on and unlock it.