Tom Urtis Explains HLOOKUP

In this introductory-level article, Excel MVP Tom Urtis explains how to use HLOOKUP.

HLOOKUP is a function not as easily grasped nor widely used as its VLOOKUP counterpart, probably for good reason as most lists are vertical in nature. The picture shows an example of using the HLOOKUP function to find a lookup value (“Mar” in this case) along row 1, hence the “H” in "HLOOKUP" referring to a horizontal lookup action.  Read complete article at AtlasPM.com