Vlookup and Hlookup

Format:
=Vlookup(lookup_value,table_array,col_index_num,match)
=Hlookup(lookup_value,table_array,row_index_num,match)

lookup_value: is the value to search for in the first column of the table_array.

table_array: is two or more columns of data that is sorted in ascending order.

col_index_num: is the column number in table_array from which the matching value must be returned. The first column is 1.

row_index_num: is the row number in table_array from which the matching value must be returned. The first row is 1.

match determines: if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.

Examples:
In the image below, if you were to type the following function in cell a8: =vlookup(21987,a2:b5,2,false), you would get the name Tom.

If you were to type the following in cell a8: =HLOOKUP("name", A1:B4,5,FALSE), you would get the name Danny.

Vlookup can be a very valuable tool and used in many ways. Read more about it HERE