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
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.
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
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.
Enable TPM 2.0 on your PC - Microsoft Support
How to enable TPM. If you need to enable TPM, these settings are managed via the UEFI BIOS (PC firmware) and vary based on your device. You can access these settings by choosing: Settings > Update & Security > Recovery > Restart now. From the next screen, choose Troubleshoot > Advanced options > UEFI Firmware Settings > Restart to make the changes.
Getting ready for the Windows 11 upgrade - Microsoft Support
If you're running Windows 8.1 or earlier, or if your PC doesn't meet the minimum system requirements to run Windows 11, consider moving to a new Windows 11 device. Find a PC that meets your needs. Set up your Microsoft account to transfer files and favorites. One account connects your device across Microsoft apps and services like Microsoft 365, OneDrive, Edge, and Microsoft Store.
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.
Which version of Windows operating system am I running?
Find operating system info in Windows 8.1 or Windows RT 8.1. To find out which version of Windows your device is running, press the Windows logo key key + R, type winver in the Open box, and then select OK.. If your device is running Windows 8.1 or Windows RT 8.1, here’s how to learn more:
Change or reset your PIN - Microsoft Support
If you forgot your PIN and need to reset it, you can do so from the Windows sign-in screen. Look below the PIN text box: If you see I forgot my PIN , select it and follow the instructions to reset your PIN.If there are multiple accounts on the device, choose the one you need to reset.