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.

Troubleshoot issues that occur when setting up external monitors. If you are trying to set up an external monitor and it’s not working, press the Windows logo key + P to make sure that the Extend option is selected. If the Extend option is selected, try the following troubleshooting tips.

If you’re having sound or audio problems, the following suggestions might help. The tips are listed in order, so start with the first one, see if that helps, and then continue to the next one if it doesn’t.

How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.

Note: Hard drives are defragmented, which is reorganizing the files so that they are all lined up and easier for the drive to read.Solid-state drives (SSDs) are what's known as "trimmed," which is basically telling the drive where it can safely do cleanup work when it's not busy doing more important things like saving or loading your files.

The Office app is running in the background. If the file is not shared on a network or if you are certain that no one is currently editing it, then an instance of the Office app with the file open might be running in the background.

How to create a Scheduling poll. Date Picker: The date picker will allow you to pick different dates to see time availability.You can add times from different dates to a poll. Alternatively, you can use the left and right arrow buttons to go to the previous or next day and use the calendar icon (between the arrow buttons) to jump back to today.

To find touchpad devices, select Human Interface Devices or Mice and other pointing devices, then right-click the device you'd like to update.

Track and print results. When you create and send an email with voting buttons to others, you may want to track and print the results. You can either quickly copy the voting results into a blank Word document or a new email, or copy them into Excel so you can work with the data later.

To resize the image, select the image to see drag handles appear around the image. Move the drag handles to resize the image as necessary. Select the Picture Format tab on the ribbon, then use the options on it to format your image. For example, you can apply a style or a border to the image.