The HLOOKUP Function

Published on: April 30, 2016

Welcome to the 28th Easy Excel tutorial. Today I introduce to you hlookup.

Last time, I covered vlookup and if you understood vlookup, then hlookup will be a breeze for you! It's exactly the same idea and same concept, except, instead of using columns (or vertical data), we use rows (horizontal data).

There are two types of hlookup, approximate hlookup and exact hlookup. Different situations call for the different types.

Watch this tutorial to get a full understanding of how HLOOKUP() really works!

Remember to checkout the Resources section below for associated downloadable content, JSFiddle links, and other resources. Watch the video and follow along!


Download the associated Excel Spreadsheet here: Download