# Vloolup Vs Hlookup Formula

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.

# Vloolup Vs Hlookup Formula

Vloolup Vs Hlookup Formula in Excel

When you want to pull information from a table, the Excel VLOOKUP function is a typical solution. VLOOKUP is a function to lookup up and retrieve data in a table. The “V” in VLOOKUP stands for vertical, which means the data in the table must be arranged vertically, with data in rows.
VLOOKUP requires that the table be structured so that lookup values appear in the left-most column. The data you want to retrieve (result values) can appear in any column to the right. When you use VLOOKUP, imagine that every column in the table is numbered, starting from the left. To get a value from a particular column, simply supply the appropriate number as the “column index”
To use VLOOKUP, you supply 4 pieces of information, or “arguments”:

The value you are looking for (lookup_value)
The range of cells that make up the table (table_array)
The number of the column from which to retrieve a result (column_index)
The match mode (range_lookup, TRUE = approximate, FALSE = exact)
HLOOKUP searches for a value in the first row of a table. At the match column, it retrieves a value from the specified row. Use HLOOKUP when lookup values are located in the first row of a table.
ange_lookup controls whether value needs to match exactly or not. The default is TRUE = allow non-exact match.
Set range_lookup to FALSE to require an exact match.
If range_lookup is TRUE (the default setting), a non-exact match will cause the HLOOKUP function to match the nearest value in the table that is still less than value.
When range_lookup is omitted, the HLOOKUP function will allow a non-exact match, but it will use an exact match if one exists.
If range_lookup is TRUE (the default setting) make sure that lookup values in the first row of the table are sorted in ascending order. Otherwise, HLOOKUP may return an incorrect or unexpected value.
If range_lookup is FALSE (require exact match), values in the first row of table do not need to be sorted.

# Our Other Services

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788

### Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!