Skip to content
Related Articles

Related Articles

Improve Article

Difference between HLookup and VLookup

  • Last Updated : 09 Mar, 2021

HLookup :
Horizontal Lookup function is called as HLookup function. This function used to find values horizontally across a set of rows in a table. It looks for a value horizontally across the lookup table. It returns an approximate or exact value based on the row number given in Excel. VLookup function provides the same lookup value as HLookup function provides.

Syntax of HLookup

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]).

VLookup :
Vertical Lookup function is called as VLookup function. This function is used to find values vertically across a set of rows in a table. It looks for a value vertically across the lookup table.  It returns an exact or approximate value based on the column number given in Excel. 

Syntax of VLookup

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

Difference between HLookup and VLookup :



S.NO.

HLOOKUP

VLOOKUP

01.It assumes that data is arranged as a table with different elements of the information in different rows.Whereas it assumes that data is arranged as a table with different elements of the information in different columns.
02.It looks for a value horizontally across the lookup table.It looks for a value vertically across the lookup table.
03.The use of HLookup function is less as compared to VLookup function.The use of VLookup function is more than compared to HLookup function.
04.It is used when data is listed in rows.Whereas it is used when data are listed in columns.
05.In HLookup function, the value the user is searching in the table or range must be in the top-most column. In VLookup function, the value the user is searching must be located in the left-most column of the table or range.
06.HLookup function returns the searched value in the same column.VLookup function returns the searched value in the same row but in the next column. 
07.The H in the HLookup function stands for horizontal searchThe V in VLookup function stands for Vertical search.
08.It is used to find out data from a range in the bottom-most range.It helps to find out the data in the leftmost column.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

 

My Personal Notes arrow_drop_up
Recommended Articles
Page :