What is HLOOKUP in Excel?
HLOOKUP is a function that is used to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify but this lookup function is not very popular because most of the tables that we deal with are vertical hence this function is not very popular.
Excel HLOOKUP Function with Formula Examples
Excel has several functions to search data from a table. HLOOKUP() function is one of them. The ‘H’ in the HLOOKUP() function stands for ‘horizontal’. This function generally helps to find a value from a row of an array or table. For this function to work the lookup value must be in the first row of the table or array. HLOOKUP() moves downward and searches for the required output. Like VLOOKUP() this function also supports exact and approximate matches.
Try using the new XLOOKUP function, An improved version of HLOOKUP that works in any direction and gives the exact match by default.