Search function in excel

1. VLOOKUPVLOOKUP function is used to find the value based on readings in the tablereferences are determined based on the number column (the data are arranged vertically).Forms of Writing= VLOOKUP (Criterion;Table_referral;No_Column_Table_referral; Rangelookup)Example:= VLOOKUP (C3; $ F $ 3: $ G $ 7; 2; TRUE)= VLOOKUP (C3, Table 1; 2; 1)2. HLOOKUPHlookup function is used to find the value based