VLOOKUP Function in excel

VLOOKUP is the popular and widely used formula in MS Excel. VLOOKUP function searches given value ( lookup_value) in the left most column of the table and returns the value in the  given column (col_index_num) of the matching row. The syntax for VLOOKUP is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value: lookup_value … Read more »