What is 'I-ILOOKUP'? How it is different from 'VLOOKUP'? Explain its syntax.

HLOOKUP function, searches for a value in the first row of a table array and returns the corresponding value in the same column from another row of the same table array. Vlookup function searches and matches first the required value from column of the range of cells and then returns the value from any cell on the same row of the range. Syntax HLOOKUP (lookup_value, table_array, row_index_num, range_lookup) Where. • Lookup_value : The value to search for in the first row of table array. • Table array: Two or more rows of data. The values in the first row of the table_array are the values searched for lookup_value. These values can be text, numbers or logical values uppercase and lower case texts are equivalent. • Row_index_num : The row number in table_array from which the corresponding value must be returned, A row_index_num of $\displaystyle 2$ returns the value in the second column in table_array; a row_index_num of $\displaystyle 3$ returns the value in the third column table_array and so on. • Range_lookup : A logical value that specifies weather we want HLOOKUP to find an exact match or an approximate match. If set to ‘False’, a corresponding value will be returned only if an exact match is found. If set to ‘True’, the nearest match will be considered if an exact one is not found.