An implementation of the vlookup in Excel could be:
You have an Excel
table with student names and their grades.
You wish that you could somewhere
in the sheet type a student name, and immediately retrieve his grade (based on
the data in the table).
To achieve this, you can use "Vlookup": the function
will look for the student’s name in the first column in the table, and will
retrieve the information that is next to his name in the second column (which is
his grade).
Hlookup is the same excpet it is for data arranged by rows instead of columns.
SOURCE: what is vlookup & hlookup?
1024x768
Normal
0
false
false
false
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
These are Excel functions for Lookup tables. The purpose of
Lookup tables is to bring a value to the table, find the closest (or exact)
match, and then return another value.
An example is the federal income tax table. On your tax
return you get your gross income and number of dependents, go to the Lookup
table, and find your taxable income.
The V in VLOOKUP means that the table is vertical; HLOOKUP
has a horizontal orientation.
If you use the Insert Function button in Excel and paste
either function, the dialog box will explain each required field separately
with examples.
1,204 views
Usually answered in minutes!
×