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
Getting started with the new Outlook for Windows
Windows Mail and Calendar apps. If you're using Windows Mail and Calendar and your accounts are supported in new Outlook, you will see a toggle in the upper right of the Mail app in Windows 10 and 11 to Try the new Outlook.. This option downloads the new app and switches your preferred email client.
Applies To: New Outlook for Windows
Camera doesn't work in Windows - Microsoft Support
Test your camera with the Camera app. Select Start , then choose Camera from your apps. If you're asked to allow access to the Camera, select Yes.If the camera works in the Camera app, the problem might be with the app you're trying to use.
Get the latest Windows update - Microsoft Support
Windows devices may get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR).. Windows will let you know if you need to restart your device to complete an update, and you can choose a time that works best for you to complete that update.
Use the System File Checker tool to repair missing or corrupted system ...
Swipe in from the right edge of the screen, and then tap Search.Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search.Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator.If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.
Fix Bluetooth problems in Windows - Microsoft Support
Before you start. Check these things before you start troubleshooting Bluetooth on your device: Check your product information. If you’re setting up a new device and Bluetooth is missing, check the product specifications to make sure it has Bluetooth capabilities.
Upgrade Windows Home to Windows Pro - Microsoft Support
Important: The following steps apply only to devices currently running an activated copy of Windows 11 Home.If you’re not activated, we recommend you activate Windows 11 Home first. For more info, see Activate Windows.
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.
Start your PC in safe mode in Windows - Microsoft Support
Safe mode starts Windows in a basic state, using a limited set of files and drivers. If a problem doesn't happen in safe mode, this means that default settings and basic device drivers aren't causing the issue.
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