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 XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match. =XLOOKUP (lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) Argument. Description.

Uninstall or remove apps and programs in Windows. There are different ways to remove apps and programs, so if you can't find the one you're looking for, you can try another location. Note that some apps and programs are built into Windows and can't be uninstalled.

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. Run the System File Checker tool (SFC.exe)

If you're looking for Help on specific Excel Add-ins, such as Solver or Inquire, see Help for Excel for Windows add-ins. If you're looking for additional help with Excel add-ins using the COM Add-ins dialog box, see Add or remove add-ins in Excel. Get a Microsoft 365 Add-in for Excel.

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result.

Learn how to add user accounts in Windows 10 and Windows 11. With an account, each person has separate files, browser favorites, and a private desktop.

Training: Watch and learn how to use Word in Windows. Explore Microsoft Word training guides, articles, and how-to videos.

Some Office 2019, Office 2016, and Office 2013 products come with a product key. If yours did, before installing Microsoft 365 for the first time, sign in with an existing or new Microsoft account and enter your product key at office.com/setup. Redeeming your key is what links your account with Microsoft 365 so you only have to do this once.

OneDrive for Business More... If you accidentally delete a file or folder in OneDrive, you may be able to recover it later from the OneDrive recycle bin, and if you're a Microsoft 365 subscriber, you can even restore your entire OneDrive if something goes wrong.