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. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

Type about in the search box on your taskbar, and then select About your PC. View your PC info. View your PC info.

Select the drive you want to clean up, and then select OK. Under Files to delete, select the file types to get rid of. To get a description of the file type, select it. Select OK. If you need to free up more space, you can also delete system files: In Disk Cleanup, select Clean up system files. Select the file types to get rid of.

Change the screen resolution. Stay in, or open, Display settings. Open your Display settings. In the Display resolution row, select the list and choose an option. It's usually best to stick with the one that's marked (Recommended). Monitors can support resolutions that are lower than their native resolutions, but text won't look as sharp and ...

Select Start > Settings > Windows Update > Check for updates. If there is an available update, select Install now. Check for updates. Make sure that your app works with Windows 11. For more info, see Your app doesn't work with Windows. Update Microsoft Store. Select Start, then from the apps list, select Microsoft Store.

To manually install SP1 from Windows Update: Select the Start button > All programs > Windows Update. In the left pane, select Check for updates. If any important updates are found, select the link to view available updates. In the list of updates, select Service Pack for Microsoft Windows (KB976932) and then select OK.

To open the On-Screen Keyboard. Go to Start , then select Settings > Accessibility > Keyboard, and turn on the On-Screen Keyboard toggle. A keyboard that can be used to move around the screen and enter text will appear on the screen. The keyboard will remain on the screen until you close it. Note: To open the OSK from the sign-in screen, select ...

Open Safari, then choose Safari > Preferences, then select General. In the Homepage field, enter a wepage address. To simply use the webpage you're currently viewing, select Set to Current Page. Choose when your homepage is shown. Open new windows with your homepage: Select the New windows open with pop-up menu, then choose Homepage.

Xbox Support offers help for Xbox, Game Pass, and billing questions. Get advice and customer service in the Xbox Support community.

Select Start > Settings > System > Activation . Select Change product key, and then enter the 25-character product key. Open Activation settings. If you've made a major change to your device's hardware, such as a motherboard replacement, run the Windows Activation troubleshooter located on the activation settings page.