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.

You can use installation media (a USB flash drive or DVD) to install a new copy of Windows, perform a clean installation, or reinstall Windows. To create installation media, go to the software download website, where you'll find step-by-step instructions.

If some Windows functions aren't working or Windows crashes, use the System File Checker to scan Windows and restore your files. Though the steps below might look complicated at first glance, just follow them in order, step-by-step, and we’ll try to get you back on track.

Use the Office offline installer to install Office 2016 or Office 2013 if you don't have an active Internet connection or you're having problems with slow speed or unreliable connections.

Enable and disable your touchscreen in Windows. Windows 10. In the search box on the taskbar, type device manager, then select Device Manager. Select the arrow next to Human Interface Devices and then select HID-compliant touch screen. (There may be more than one listed.)

Playing games with others in a club. The easiest way to play games in a club is to join or start a party within a club, and then use the Looking for Group feature to search for teammates who have similar gaming objectives, playing styles, and preferences.

Install Microsoft 365 2019 or 2016 on a PC. Remember a one-time purchase version of Microsoft 365 is licensed for one install only. Depending on your browser, select Open file (in Edge or Internet Explorer), Setup (in Chrome), or Save File (in Firefox).

Change from a 32-bit version to a 64-bit version or vice versa. Activate Windows. Fix Bluetooth problems in Windows. Learn how to install, reinstall, or activate Microsoft 365 or Office 2019 on a PC or Mac.

Activity history helps keep track of the things you do on your device, such as the apps and services you use, the files you open, and the websites you browse. Your activity history is stored locally on your device. You can manage activity history settings to choose what to store.

Free up drive space in Windows. If your PC is running low on free space, you might not be able to install important Windows updates, and your PC’s performance may be affected. Here are some ways to free up space so you can keep your PC up to date and running smoothly.