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).

Step 1: Go to www.office.com/setup or Microsoft365.com/setup. Step 2: Sign in with your Microsoft account, or create one if you don't have one. Be sure to remember this account so that you can install or reinstall Office later, without a product key.

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.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

share their data. You can learn more about Mic rosoft’s data collection and use in the product

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. 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.

The INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.

Go to Home > Replace. Enter the word or phrase you want to replace in Find what. Enter your new text in Replace with. Choose Replace All to change all occurrences of the word or phrase. Or, select Find Next until you find the one you want to update, and then choose Replace.

You can change the capitalization, or case, of selected text in a document by selecting a single button on the Home tab called Change Case. Note: For information on automatic capitalization rules, see Choose AutoCorrect options for capitalization, spelling, and symbols.

Find your files in Windows 11 using one of these methods. Search from the taskbar: Type the name of a document (or a keyword from it) into the search box on the taskbar. You'll see results for documents across your PC and OneDrive.