MS Excel HLOOKUP functions for exact data

Smoke Studios

In this tutorial, we will explore how to use the HLOOKUP function in Microsoft Excel for exact matches. The HLOOKUP function searches for a value in the top row of a table and returns data from a specified row within that table. By setting the range lookup to FALSE, you can retrieve an exact value such as product codes, exam scores, or employee IDs arranged horizontally. We will walk through the HLOOKUP syntax, explain each argument, and demonstrate examples where exact matching is required.  #Excel #HLOOKUP #ExcelTutorial

Transcript

00:00So as per this table, let's say I want to display out price based on the product the user types.

00:06In that case, what I can do is I can go to the price section, press equals and type in at look

00:11up right here because I'm looking for a horizontal data. Then choose the table array reference right

00:17here, press comma and select out the table range right here just like this. Then go ahead and press

00:23comma right here and I want to display out price which is on the second row so I'm just going to

00:28press two and press comma right here. So I want an exact match so I'm just going to go ahead and say

00:33false right here just like this so it does not bring up the midrange. Press enter right here and

00:38now as you type in the product right here, you can see the exact price. Go ahead and type in keyboard

00:44right here just like this, you see the exact price. You type something else, it won't display right here

00:50just like this.

Category

Transcript

Comments

Recommended