VLOOKUP is used to read the vertical table_array and HLOOKUP is used for the horizontal table

Syntax:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
Look_up_value can be a value, a reference, or a text string and used to match between table array and data.
Col_index_num is the column index number of table_array. The only difference between HLOOKUP and VLOOKUP is HLOOKUP use row_index_num (row index number of table_array).
Range_lookup is a logical value that specifies whether you want VLOOKUP to find the exact match or approximate match.
Click HERE to download LOOKUP tutorial