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