
Excel with Look up Function
Excel with Look up Function: VLOOKUP:-Vlookup is an excel function to lookup and retrieve data from a specific column. Vlookup support approximate and exact match. The v stands for vertical lookup. Syntax:- = VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUM,[RANGE_LOOKUP]) Parameters:- Lookup_Value:- the value you want to look for. Table_Array:- table from which retrieve the values. Col_Index_Num:- the column of the…