Pinterest Pixel

HLOOKUP Function in Excel: Introduction

What does it do? Searches for a value in the first row of a table array and... read more

Download Excel Workbook
Bryan
Posted on

Overview

HLOOKUP Function in Excel: Introduction | MyExcelOnline HLOOKUP Function in Excel: Introduction | MyExcelOnline

What does it do?

Searches for a value in the first row of a table array and returns a value in the same column from another row (downwards) in the table array.

Formula breakdown:

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

What it means:

=HLOOKUP(this value, in this list, and get me value in this row, [Exact Match/FALSE/0])


Ever had a horizontal table and you want to search for values in the table easily?

I’m sure you do!  There is a simple way to do this with Excel’s HLOOKUP function!

This is very similar to the VLOOKUP Function! The only difference is instead of working with vertical tables, you get to do the same thing for horizontal tables!

Let’s try it out on this horizontal table!

HLOOKUP Function in Excel: Introduction

Using the HLOOKUP function let us get the following values from this table:

  • What is the price of a television?
  • What is the cost of a tablet?

I explain how you can do this below:

Download excel workbookHLOOKUP.xlsx

Want to know how to use the HLOOKUP function from Beginner to Advanced?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch it on YouTube and give it a thumbs-up!

download the youtube excel practice fileHLookUp.xlsx

STEP 1: Let us target the first question: What is the price of a television?

We need to enter the HLOOKUP function in a blank cell:

=HLOOKUP(

HLOOKUP Function in Excel: Introduction

 

STEP 2: The HLOOKUP arguments:

lookup_value

What is the name of the column?

We want to find the column that matches “Television”

=HLOOKUP(“Television”,

HLOOKUP Function in Excel: Introduction

table_array

What is our list?

Select the entire table!

=HLOOKUP(“Television”, A8:D10,

HLOOKUP Function in Excel: Introduction

row_index_num

Which row should we get our value from?

We want the price, so it’s row #2 in our table!

=HLOOKUP(“Television”, A8:D10, 2,

HLOOKUP Function in Excel: Introduction

[range_lookup]

Do we want an appropriate match or exact match?

We want an exact match, so specify FALSE here.

=HLOOKUP(“Television”, A8:D10, 2, FALSE)

HLOOKUP Function in Excel: Introduction

You now have your television price!

HLOOKUP Function in Excel: Introduction

 

STEP 3: Now let us try doing the same for the cost of the Tablet!

The column name is “Tablet”, and the cost is on row #3 in our table:

=HLOOKUP(“Tablet”, A8:D10, 3, FALSE)

HLOOKUP Function in Excel: Introduction

You now have your tablet cost!

HLOOKUP Function in Excel: Introduction

 

HLOOKUP Function in Excel

HLOOKUP Function in Excel: Introduction | MyExcelOnline

 

HLOOKUP Function in Excel: Introduction

If you like this Excel tip, please share it
HLOOKUP Function in Excel: Introduction | MyExcelOnline HLOOKUP Function in Excel: Introduction | MyExcelOnline
HLOOKUP Function in Excel: Introduction | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  The Ultimate Guide on How to Add and Subtract Dates in Excel

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...