Hlookup

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…