VLOOKUP FORMULA IN EXCEL

The VLOOKUP function searches up and down (leading to bottom) the leftmost column of a table until a value that matches or surpasses the one you are seeking out is located.

The aspects being searched for have to be special and must be arranged or sorted in ascending order.

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