The Excel HLOOKUP function explained in simple terms
The HLOOKUP function in Excel is a useful feature for anyone who wants to look for specific values in a table. This requires all the compared values to be located in the same row (i.e. horizontally arranged). You can save a lot of time by using the HLOOKUP function, especially when dealing with large data sets, as our HLOOKUP example will illustrate.