KEMBAR78
Excel Vlookup | PDF
Scribd
Upload
17K views2 pages

Excel Vlookup

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.

Uploaded by

api-297910907
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
17K views2 pages

Excel Vlookup

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.

Uploaded by

api-297910907
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 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