- #HOW TO USE MICROSOFT EXCEL 2013 FUNCTIONS UPGRADE#
- #HOW TO USE MICROSOFT EXCEL 2013 FUNCTIONS SOFTWARE#
Once the XLOOKUP Function is selected, the Function Arguments dialog box appears as shown in the image below: XLOOKUP(lookup_value array return_array if_not_found match_mode search_mode) You don’t need to be connected to the Internet to use Office applications, such as Word, Excel, and PowerPoint.
#HOW TO USE MICROSOFT EXCEL 2013 FUNCTIONS UPGRADE#
The syntax of the XLOOKUP Functions is the below: Upgrade from Excel 2013 to Microsoft 365. What does the XLOOKUP Function do? It Searches A Range Or An Array For A Match And Returns The Corresponding Item From A Second Range Or Array.
#HOW TO USE MICROSOFT EXCEL 2013 FUNCTIONS SOFTWARE#
Once the Lookup & Reference category is selected the drop-down menu appears with all the available Functions, which in my example is the Function XLOOKUP. Microsoft Excel 2013 is the latest version of the incredible spreadsheet software used the World over. In the image below, I have selected the Formulas tab, and then from the Function Library area of the ribbon, I have selected the Lookup & Reference Category as shown. Information such as the Title of the Show, the Network that created the Show and the Viewers of the Show. Say, now that we want to find out all the information that is related with the Show that is in the Rank 96. The Rank of each TV Show depends on the percentage of Viewers.
You’ll then see the Function Arguments tool open for you to set up the formula using the function. Then, either double-click the function in the list or select it and click OK. I have the Rank number of the TV Show among with the Network that has created the TV Show and the percentage of Viewers watching the TV Shows. When you locate the function you want to use, be sure you have the cell selected where you want to insert it. Use this function when you need to look in a single row or column and find a value from the same position in a second row or column. Heres a video about using the IF function.
Use this function to return one value if a condition is true and another value if its false. This Table contains information about TV Shows. Use this function to add the values in cells. In the image below, I have entered Data into a Table.