Vlookup & Hlookup

Vertical Lookup & Horizontal Lookup

This is back of MS Excel formula, If you want to compare two datasheet, data table on basis of common column then we use vlookup & H lookup formula.

Vlookup (short for ‘vertical’ lookup) is a built-in Excel function that is designed to work with data that is organised into columns. For a specified value, the function finds (or ‘looks up’) the value in one column of data, and returns the corresponding value from another column.

Syntax : Vlookup(Lookup Value,Table Array,Column Index No,False/True)

False/0 -Exact Match

True/1 -Approx Match

lookup _value: The value you want to find in the first column of the table_array.

Table_array: This is the table of data that VLOOKUP searches to find the information you are after. The table_array must contain at least two columns of data. The first column contains the lookup_values.

col_index_num: The number of the column in the table_array that contains the data you want returned.

range_lookup: A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing False will return exact matches only.

HLOOKUP

Excel’s HLOOKUP function, which stands for horizontal lookup, is used to find specific information
that has been stored in rows in a spreadsheet table.

Syntax

HLOOKUP(lookup_value,table_array,row_index_num, range_lookup)

lookup _value: The value you want to find in the first column of the table_array .

table_array: The range of data that HLOOKUP searches to find your information. The table_array must contain at least two columns of data. The first column contains the lookup_values.

row_index_num: The number of the row in the table_array that contains the data you want returned.

range_lookup: A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing False will return exact matches only.

 Pivot Table

pivot table is a tool that allows you to quickly summarize and analyze data in your spreadsheet. You can use a pivot table when

You want to arrange and summarize your data. The data in your spreadsheet is too large and complex to analyze in its original format.