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

About Bill Jelen

Author of 41 books about Microsoft Excel. View all posts by Bill Jelen

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: