WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        1744 results for match function excel

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        1744 results for match function excel

        Use MATCH function to search location information

        Use MATCH function to search location information

        02:17

        Use MATCH function to search location information

        The MATCH function can return information about the location of the lookup content based on the lookup value. Take this spreadsheet as an example. We want to find the location of the column where the contact Andrew is located. Then we can use the MATCH function. The syntax structure of MATCH function is: MATCH(lookup_value,lookup_array,match_type)In this table, we need to find out which row Andrew is located in column A by his name in cell D3. Click the Formulas tab and the Insert Func....

        Spreadsheet 15.1K views
        INDEX MATCH formulas

        INDEX MATCH formulas

        02:11

        INDEX MATCH formulas

        In the previous videos, we've learned about the usages of INDEX and MATCH formulas, respectively.The INDEX function can return a value in a cell regarding its column and row number in an array. Combining the INDEX MATCH formulas makes it flexible in value lookup. We can break the limitations of VLOOKUP and realize the reverse lookup. Here is a form recording the personal information of staff. How can we look up the 'Number' of a corresponding staff? We can run the INDEX MAT....

        Spreadsheet 9.7K views
        The Advanced XLOOKUP Function

        The Advanced XLOOKUP Function

        08:33

        The Advanced XLOOKUP Function

        What type of lookup function are you using?VLOOKUP? HLOOKUP? Or...King of the Lookup function-XLOOKUP function is available now!With the XLOOKUP function, you can search for a match in a range or array and return the corresponding item through the second range or array.· The powerful lookup functionSuppose we want to look up Rico's department.Enter=XLOOKUP, and press the TAB key. We need to answer three questions for mandatory arguments.1, what is the keyword for lookup values?Ente....

        Spreadsheet 13.4K views
        How to use the VLOOKUP function

        How to use the VLOOKUP function

        04:29

        How to use the VLOOKUP function

        The clever use of VLOOKUP function can help us quickly find the relevant results. It is usually used to check and match the data between multiple tables. Take this table as an example. In the table on the right, we know the "Number" and "Name" of the "Group1" members, so we are looking for the "Chemistry" scores of the members.1. Click cell J3, and click "Insert Function".2.Click "Lookup and Reference" in "Category", and choose "VLOOKUP" function.3.In the popup dialog box, we can see t....

        Spreadsheet 24.9K views
        The INDEX function

        The INDEX function

        03:50

        The INDEX function

        The INDEX function can look up a value regarding its row and column numbers.There are two forms of the INDEX function, the Array form and the Reference form. · One: Array formWe'll use the Array form to return the value located in the seventh row and the fourth column.First, select cell J6. Next, click Formulas and then Insert Function to insert the INDEX function. The function syntax:INDEX(array,row_num,column_num)The first parameter, 'Array', refers to the array for valu....

        Spreadsheet 13.9K views
        A magical function everyone needs to know: VLOOKUP

        A magical function everyone needs to know: VLOOKUP

        12:04

        A magical function everyone needs to know: VLOOKUP

        1. Introduced the basic use of the VLOOKUP function, including the use of exact search and fuzzy search2. lists the 3 cases where the VLOOKUP function is prone to incorrect values.3. combine the MATCH function + VLOOKUP function together to create a more convenient effect.

        Spreadsheet 7.7K views
        The Trace Precedents function

        The Trace Precedents function

        00:57

        The Trace Precedents function

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of Tracking Precedents of WPS table.Take this table as an example. We want to see which cells are referenced by the formula of ....

        Spreadsheet 5.9K views
        How to use the OR Function

        How to use the OR Function

        01:40

        How to use the OR Function

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. This is a promotion application form submitted by employees. The company sets two conditions for it.1. Length of service should be more than 3 years; 2: Personal KPI should be rated as A.The Applicant has the qualification to register when any one of the requirements is met. If you are the HR of the company, how can you quickly select qualified employee....

        Spreadsheet 9.4K views
        Prev 1 2 3 ... 217 218 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube