Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Vlookup (Vertical Lookup) / Table Array: Object No.: To Apply V-Lookup and Countif Formula

    Uploaded by

    Hamdan afzal
    This document discusses how to use the VLOOKUP and COUNTIF formulas in Excel. It explains that VLOOKUP can be used to lookup values from a table and return data from another column, while COUNTIF counts how many times a specific value appears in a range. It provides step-by-step instructions for using both formulas, including selecting the lookup value, table array, column index, and range for VLOOKUP, and selecting the range and criteria for COUNTIF. The document also describes how to directly find text using the Find feature.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Vlookup (Vertical Lookup) / Table Array: Object No.: To Apply V-Lookup and Countif Formula

    Uploaded by

    Hamdan afzal
    5 views5 pages
    This document discusses how to use the VLOOKUP and COUNTIF formulas in Excel. It explains that VLOOKUP can be used to lookup values from a table and return data from another column, while COUNTIF counts how many times a specific value appears in a range. It provides step-by-step instructions for using both formulas, including selecting the lookup value, table array, column index, and range for VLOOKUP, and selecting the range and criteria for COUNTIF. The document also describes how to directly find text using the Find feature.

    Original Title

    5

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses how to use the VLOOKUP and COUNTIF formulas in Excel. It explains that VLOOKUP can be used to lookup values from a table and return data from another column, while COUNTIF counts how many times a specific value appears in a range. It provides step-by-step instructions for using both formulas, including selecting the lookup value, table array, column index, and range for VLOOKUP, and selecting the range and criteria for COUNTIF. The document also describes how to directly find text using the Find feature.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    5 views5 pages

    Vlookup (Vertical Lookup) / Table Array: Object No.: To Apply V-Lookup and Countif Formula

    Uploaded by

    Hamdan afzal
    This document discusses how to use the VLOOKUP and COUNTIF formulas in Excel. It explains that VLOOKUP can be used to lookup values from a table and return data from another column, while COUNTIF counts how many times a specific value appears in a range. It provides step-by-step instructions for using both formulas, including selecting the lookup value, table array, column index, and range for VLOOKUP, and selecting the range and criteria for COUNTIF. The document also describes how to directly find text using the Find feature.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    OBJECT NO.

    : TO APPLY V-LOOKUP and COUNTIF FORMULA

     VLOOKUP (VERTICAL LOOKUP) / TABLE ARRAY :


    It is an Excel function to lookup and retrieve data from a specific column
    in table. VLOOKUP supports approximate and exact matching.
    To find out the specific information from a large amount of data in MS
    excel we find the formula of v lookup for this select the whole table of
    payroll.

    =VLOOKUP(lookup_value, table_array, col_index_number,[range_lookup])

    VLOOKUP is used to search for a value in the first column of a table


    range and return a corresponding value from another column in the
    same row.

    PROCEDURE
    Step 1
    Open your MS excel fill up the fields
    of payroll that is name, designation,
    basic salary, medical allowance,
    house rent etc.

    Step 2
    Select the next cell and
    use the formula for v
    lookup
    = VLOOKUP (The
    selected cell will show a
    number of options to be
    filled in Lookup_value,
    Table_array,
    Col_index_num,
    [range_lookup])
    *For Lookup_
    value:
    Select the cell with
    name of required
    individual to be
    search

    *For Table_ array :


    Type the name of
    payroll table (name of
    coulumn and row with
    colon) OR drag the
    mouse to select
    whole payroll table.

    *For
    column_index
    _num:
    Insert reference
    number of the
    required column
    (1,2,3…) that is
    column of
    searching

    *For Range _lookup:


    dropdown list shows
    ●True approximate
    match = gives
    approximate value
    ●False exact match =
    gives exact value
    In this case type ‘0’ .Close the
    bracket and press enter.

    s
    *The selected cell will
    show the required
    information about
    the individual you were
    searching for.

     DIRECT
    METHOD

    To directly find the


    name

    *Click find and select


    icon on home tab
    ribbon
    In drop down menu
    select replace and this type of popup dialogue will appear
    In given space write the name you want to search and click find next.

    The result of your


    search will appear
    in the Box
     TO APPLY COUNT IF FORMULA

    To count how many times a specific value has been appeared in a


    spreadsheet we will go for count if.

    PROCEDURE
    Step 1
    open an excel
    worksheet ,select any
    empty cell and type the
    formula
    = COUNTIF (the
    selected cell will show
    two options to fill in that
    is range, criteria)

    A. The range:
    Select the table or a
    specific column row or
    specific cell where you
    want to conduct the search
    (drag the mouse on whole
    column)

    B. Criteria:
    Enter the value you want
    to find
    Step 2
    Close the bracket and
    press enter.
    The cell will show
    number , that is how
    many times that
    particular figure is used
    in the particular column.

    You might also like