Scribd Logo
Upload

Welcome to Scribd!

  • 12K views

    Excel Vlookup

    Uploaded by

    api-297910907
    This document provides instructions for using the VLOOKUP function in Excel to search for tuition amounts based on a student's grade level. The VLOOKUP function looks up the grade level in cell E2 within a table array, returns the corresponding tuition from column B, and copies it to the current spreadsheet. Specifically, the function is =VLOOKUP(E2,$A$15:$B$17,2,FALSE), which looks up the value in E2 in the range A15:B17, returns the value from column 2 (B), and requires an exact match.

    Copyright:

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

    Excel Vlookup

    Uploaded by

    api-297910907
    12K views2 pages
    This document provides instructions for using the VLOOKUP function in Excel to search for tuition amounts based on a student's grade level. The VLOOKUP function looks up the grade level in cell E2 within a table array, returns the corresponding tuition from column B, and copies it to the current spreadsheet. Specifically, the function is =VLOOKUP(E2,$A$15:$B$17,2,FALSE), which looks up the value in E2 in the range A15:B17, returns the value from column 2 (B), and requires an exact match.

    Original Title

    excel vlookup

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for using the VLOOKUP function in Excel to search for tuition amounts based on a student's grade level. The VLOOKUP function looks up the grade level in cell E2 within a table array, returns the corresponding tuition from column B, and copies it to the current spreadsheet. Specifically, the function is =VLOOKUP(E2,$A$15:$B$17,2,FALSE), which looks up the value in E2 in the range A15:B17, returns the value from column 2 (B), and requires an exact match.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    12K views2 pages

    Excel Vlookup

    Uploaded by

    api-297910907
    This document provides instructions for using the VLOOKUP function in Excel to search for tuition amounts based on a student's grade level. The VLOOKUP function looks up the grade level in cell E2 within a table array, returns the corresponding tuition from column B, and copies it to the current spreadsheet. Specifically, the function is =VLOOKUP(E2,$A$15:$B$17,2,FALSE), which looks up the value in E2 in the range A15:B17, returns the value from column 2 (B), and requires an exact match.

    Copyright:

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

    Excel Tutorial

    Using VLOOKUP to search for information and copying to a new


    a Spreadsheet
    1. Download Payment
    2. Our aim is to assign the correct tuition to each Student based on the grade
    level. This information is already represented in a small table below the main
    table called the table array.
    Lets remind ourselves of the arguments of a VLOOKUP
    Like other functions in Excel the function begins with a equal sign
    (=)
    Following this is the Function Name
    - =VLOOKUP
    Open Parenthesis
    - =VLOOKUP(
    The lookup value (This is the value you want to look
    up in the table). In this case we to lookup the grade level that is
    cell E2
    - =VLOOKUP(E2,

    Table Array(This is the reference to the table you want to search


    excluding the heading)
    - A15:B17
    - Therefore your function should now be =VLOOKP(E2,A15:B17,
    The Table Array should be made ABSOLUTE. This is to keep the
    values fixed. =VLOOKP(E2,$A$15:$B$17,
    Following this one need to indicate which column within the table
    array contains the element or value you want to copy

    - Column B contains the required information which is the


    tuition. B if asked to be referred to in numbers is equivalent to
    2. Therefore the column index number is 2
    Therefore your function at this point is
    =VLOOKUP(E2,$A$15:$B$17,2

    Column B contains the


    information required

    Finally insert the approximate match. This may be False if you


    want the Exact value or TRUE if you want an approximate value.
    We want the exact therefore our function is
    =VLOOKUP(E2,$A$15:$B$17,2,False)

    You might also like