{"id":113501,"date":"2025-11-24T18:53:14","date_gmt":"2025-11-24T13:23:14","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/"},"modified":"2025-11-24T18:40:24","modified_gmt":"2025-11-24T13:10:24","slug":"hlookup-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/","title":{"rendered":"How to Use the HLOOKUP Function in Excel?"},"content":{"rendered":"\n<p>Looking for an easy way to fetch your data in Excel?&nbsp;<\/p>\n\n\n\n<p>The HLOOKUP function enables you to quickly and easily locate data in rows by searching horizontally.&nbsp;<\/p>\n\n\n\n<p>Whether you are looking at sales, prices, or any other metrics, the formula can retrieve exact information from a table.<\/p>\n\n\n\n<p>In this tutorial, we\u2019ll review how the HLOOKUP function works, use real examples, and explain all the steps to become an Excel expert.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-does-hlookup-do-in-excel\">What does HLOOKUP do in Excel?<\/h2>\n\n\n\n<p>The HLOOKUP function in Excel helps you search in the top row, then gives you a value from another row in the same column.<\/p>\n\n\n\n<p>You can use this function most effectively if your data is gathered with headers in the first row and data entries below.<\/p>\n\n\n\n<p><strong>HLOOKUP Syntax:<\/strong><\/p>\n\n\n\n<p>=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-208.png\"><img decoding=\"async\" width=\"723\" height=\"843\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-208.png\" alt=\"\" class=\"wp-image-113511\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-208.png 723w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-208-257x300.png 257w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-208-150x175.png 150w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/figure>\n\n\n\n<p><strong>Explanation of Each Argument:<\/strong><\/p>\n\n\n\n<p><strong>1. lookup_value<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The value you want to find in the <strong>first row<\/strong> of your table or data range.<\/li>\n\n\n\n<li>This can be a number, text, cell reference, or even a formula.<\/li>\n\n\n\n<li>Example: \"Q2\" or B1.<\/li>\n<\/ul>\n\n\n\n<p><strong>2. table_array<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The range of cells that contains the data you want to search through.<\/li>\n\n\n\n<li>The first row of this range is where HLOOKUP will look for the lookup_value.<\/li>\n\n\n\n<li>Example: A1:D3.<\/li>\n<\/ul>\n\n\n\n<p><strong>3. row_index_num<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The row number within your selected table where the data you want to retrieve is located.<\/li>\n\n\n\n<li>For example, 2 means the result will come from the second row of the table_array.<\/li>\n\n\n\n<li>Must be greater than or equal to 1 and less than or equal to the total number of rows in the table_array.<\/li>\n<\/ul>\n\n\n\n<p><strong>Note:<\/strong> If you type <strong>1<\/strong>, HLOOKUP will return the header itself (the first row). Since you usually want the data below the header, your Row Index Number will almost always be <strong>2 or higher<\/strong>.<\/p>\n\n\n\n<p><strong>4. [range_lookup]<\/strong> <em>(Optional)<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A logical value:<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TRUE = Approximate match (default)<\/li>\n\n\n\n<li>FALSE = Exact match<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If omitted, Excel assumes TRUE.<\/li>\n\n\n\n<li><strong>Important:\u00a0<\/strong>When using TRUE, the data in the first row must be sorted in ascending order.<\/li>\n<\/ul>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Free Course<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/excel-for-beginners\" class=\"courses-cta-title-link\">Excel for Beginners Free Course<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn essential Excel skills for data analysis, including functions, formulas, and data visualization techniques. Master cell referencing, sorting, and creating charts and presentations.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>Beginner Level<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>7.5 hrs<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/excel-for-beginners\" class=\"courses-cta-button\">\n                Enroll Free\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-by-step-guide-how-to-use-hlookup-in-excel-with-an-example\"><strong>Step-by-Step Guide: How to Use HLOOKUP in Excel (with an Example)<\/strong><\/h2>\n\n\n\n<p>Suppose you want to check the sales numbers from a certain quarter in your quarterly sales data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-1-enter-your-dataset\"><strong>Step 1: Enter Your Dataset<\/strong><\/h3>\n\n\n\n<p>Open Excel and input the following data starting from cell A1:<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-200.png\"><img decoding=\"async\" width=\"879\" height=\"345\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-200.png\" alt=\"\" class=\"wp-image-113503\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-200.png 879w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-200-300x118.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-200-768x301.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-200-150x59.png 150w\" sizes=\"(max-width: 879px) 100vw, 879px\" \/><\/figure>\n\n\n\n<p>You should have this dataset in the range A1:E2, where:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Row 1 contains quarters (Q1 to Q4).<\/li>\n\n\n\n<li>Row 2 contains the corresponding sales figures.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-2-choose-a-cell-for-the-formula\"><strong>Step 2: Choose a Cell for the Formula<\/strong><\/h3>\n\n\n\n<p>Click on a new cell, for example, <strong>A5,<\/strong> where you want to display the result of the HLOOKUP function.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-3-enter-the-hlookup-formula\"><strong>Step 3: Enter the HLOOKUP Formula<\/strong><\/h3>\n\n\n\n<p>Now, enter the following formula in <strong>cell A5<\/strong>:<\/p>\n\n\n\n<p>=HLOOKUP(\"Q3\", A1:E2, 2, FALSE)<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-201.png\"><img decoding=\"async\" width=\"884\" height=\"401\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-201.png\" alt=\"\" class=\"wp-image-113504\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-201.png 884w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-201-300x136.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-201-768x348.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-201-150x68.png 150w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/figure>\n\n\n\n<p><strong>Explanation of the formula:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\"<\/strong><strong>Q3<\/strong><strong>\"<\/strong>: The value to look for in the top row.<\/li>\n\n\n\n<li><strong>A1:E2<\/strong>: The range containing your data.<\/li>\n\n\n\n<li><strong>2<\/strong>: The row number containing the answers (Sales).<\/li>\n\n\n\n<li><strong>FALSE<\/strong>: Ensures Excel looks for \"Q3\" exactly, not a partial match.<\/li>\n<\/ul>\n\n\n\n<p><strong>Pro Tip: Locking Your Table<\/strong><\/p>\n\n\n\n<p>In this example, we used the range A1:E2.&nbsp;<\/p>\n\n\n\n<p>However, in professional reports, it is best practice to \"lock\" your table range by adding dollar signs ($), like this: $A$1:$E$2.<\/p>\n\n\n\n<p>This is called an Absolute Reference.&nbsp;<\/p>\n\n\n\n<p>It ensures that if you copy and paste this formula to another cell, the reference to your data table stays fixed and doesn't move, preventing errors.<\/p>\n\n\n\n<p>To keep the examples below simple and easy to read, we have skipped the dollar signs. You only need them if you plan to copy the formula to other cells.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-4-press-enter\"><strong>Step 4: Press Enter<\/strong><\/h3>\n\n\n\n<p>Once you press Enter, the result will display as: <strong>2000<\/strong>, the sales figure for Q3.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-209.png\"><img decoding=\"async\" width=\"803\" height=\"371\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-209.png\" alt=\"\" class=\"wp-image-113513\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-209.png 803w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-209-300x139.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-209-768x355.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-209-150x69.png 150w\" sizes=\"(max-width: 803px) 100vw, 803px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-5-try-a-cell-reference-instead-of-a-direct-value\"><strong>Step 5: Try a Cell Reference Instead of a Direct Value<\/strong><\/h3>\n\n\n\n<p>To make the formula more dynamic, replace \"Q3\" with a <strong>cell reference<\/strong>.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In cell <strong>G1<\/strong>, type: Q2<\/li>\n\n\n\n<li>In cell <strong>A5<\/strong>, use this formula:<\/li>\n<\/ol>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-202.png\"><img decoding=\"async\" width=\"950\" height=\"404\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-202.png\" alt=\"\" class=\"wp-image-113505\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-202.png 950w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-202-300x128.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-202-768x327.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-202-150x64.png 150w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/figure>\n\n\n\n<p>The answer will be 1500<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-210.png\"><img decoding=\"async\" width=\"903\" height=\"404\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-210.png\" alt=\"\" class=\"wp-image-113512\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-210.png 903w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-210-300x134.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-210-768x344.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-210-150x67.png 150w\" sizes=\"(max-width: 903px) 100vw, 903px\" \/><\/figure>\n\n\n\n<p>Now, the lookup value will depend on the value in <strong>G1<\/strong>. Try changing G1 to Q4 and see if the result updates to <strong>2500<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-6-what-happens-with-an-incorrect-or-missing-value\"><strong>Step 6: What Happens with an Incorrect or Missing Value?<\/strong><\/h3>\n\n\n\n<p>Try entering an invalid quarter in G1, like Q5, with the formula =HLOOKUP(G1, A1:E2, 2, FALSE) and it will return: #N\/A<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-206.png\"><img decoding=\"async\" width=\"881\" height=\"417\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-206.png\" alt=\"\" class=\"wp-image-113508\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-206.png 881w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-206-300x142.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-206-768x364.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-206-150x71.png 150w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/figure>\n\n\n\n<p>This indicates that the exact match couldn\u2019t be found in the first row.<\/p>\n\n\n\n<p><strong>Summary:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>HLOOKUP is great for horizontally structured data.<\/li>\n\n\n\n<li>Always define a clear <strong>lookup row<\/strong> (first row in the range).<\/li>\n\n\n\n<li>Use FALSE for an exact match to avoid unexpected results.<\/li>\n\n\n\n<li>Replace static values with <strong>cell references<\/strong> for dynamic lookup.<\/li>\n<\/ul>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Academy Pro<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\" class=\"courses-cta-title-link\">Microsoft Excel Course<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn Excel the smart way! Our course teaches you all the essential tools and techniques to master spreadsheets, from formulas to charts, and improve your workflow in every task you do.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>10 Hrs<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>2 Projects<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\" class=\"courses-cta-button\">\n                Learn Excel\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"more-practical-examples-of-hlookup\"><strong>More Practical Examples of HLOOKUP<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"example-1-simple-exact-match-to-find-a-students-score\"><strong>Example 1: Simple Exact Match to Find a Student\u2019s Score<\/strong><\/h3>\n\n\n\n<p><strong>Scenario<\/strong>:&nbsp;<\/p>\n\n\n\n<p>You have a table of students' scores in different subjects. You want to look up the score of a specific student in a particular subject.<\/p>\n\n\n\n<p><strong>Sample Data (starting at cell A1)<\/strong><\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-207.png\"><img decoding=\"async\" width=\"644\" height=\"270\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-207.png\" alt=\"\" class=\"wp-image-113510\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-207.png 644w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-207-300x126.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-207-150x63.png 150w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/figure>\n\n\n\n<p><strong>Objective:<\/strong> Find Alice\u2019s score in Math.<\/p>\n\n\n\n<p><strong>Formula:<\/strong><\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-204.png\"><img decoding=\"async\" width=\"761\" height=\"398\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-204.png\" alt=\"\" class=\"wp-image-113507\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-204.png 761w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-204-300x157.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-204-150x78.png 150w\" sizes=\"(max-width: 761px) 100vw, 761px\" \/><\/figure>\n\n\n\n<p><strong>Explanation:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\"Alice\" is the student you want to look up.<\/li>\n\n\n\n<li>A1:D2 is the table containing names and scores.<\/li>\n\n\n\n<li>2 indicates you want the value from the second row (Math scores).<\/li>\n\n\n\n<li>FALSE enforces an exact match.<\/li>\n<\/ul>\n\n\n\n<p><strong>Result:<\/strong> 78<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"blob:https:\/\/www.mygreatlearning.com\/8906b826-d8a3-421e-89d2-e0ceda5649de\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"example-2-using-wildcards-for-partial-text-matches\"><strong>Example 2: Using Wildcards for Partial Text Matches<\/strong><\/h3>\n\n\n\n<p><strong>Scenario:&nbsp;<\/strong><\/p>\n\n\n\n<p>You want to find a student's math score, but you only know their name starts with \"Da\" (e.g., David).<\/p>\n\n\n\n<p>You can use a wildcard character (the asterisk *) to tell Excel to look for any text that follows Da\":*.<\/p>\n\n\n\n<p><strong>The Formula: <\/strong><strong><br><\/strong>To find the score for the student starting with \"Da\", enter this formula:<\/p>\n\n\n\n<p>=HLOOKUP(\"Da*\", A1:D2, 2, FALSE)<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-212.png\"><img decoding=\"async\" width=\"686\" height=\"243\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-212.png\" alt=\"\" class=\"wp-image-113515\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-212.png 686w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-212-300x106.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-212-150x53.png 150w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/figure>\n\n\n\n<p><strong>Result:<\/strong> <strong>92<\/strong> (This is David's score).<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-213.png\"><img decoding=\"async\" width=\"591\" height=\"207\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-213.png\" alt=\"\" class=\"wp-image-113516\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-213.png 591w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-213-300x105.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-213-150x53.png 150w\" sizes=\"(max-width: 591px) 100vw, 591px\" \/><\/figure>\n\n\n\n<p><strong>Explanation:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\"Da\"*: The asterisk (*) is a wildcard that represents any number of characters. Excel reads this as \"Find a cell that starts with 'Da' and has anything (or nothing) after it.\"<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A1:D2: The range containing the names and scores.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>2: You want the data from the second row (the scores).<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>FALSE: Crucial Step.<br>You must use FALSE (Exact Match) for wildcards to work correctly.\u00a0<\/li>\n<\/ul>\n\n\n\n<p>If you use TRUE, Excel will treat the wildcard as a standard character or try to find the closest sorted value, which will give you an error or the wrong result.<\/p>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;<\/p>\n\n\n\n<p>HLOOKUP searches from left to right and stops at the <strong>first match<\/strong> it finds.&nbsp;<\/p>\n\n\n\n<p>If you have a student named \"Daniel\" listed before \"David,\" the formula will return Daniel's score because he also matches \"Da*\".<\/p>\n\n\n\n<p>Now that we've covered exact and partial matches, let's look at how to handle scenarios where an exact match isn't required.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"example-3-calculating-sales-commissions-approximate-match\"><strong>Example 3: Calculating Sales Commissions (Approximate Match)<\/strong><\/h3>\n\n\n\n<p><strong>Scenario<\/strong>:<\/p>\n\n\n\n<p>You want to assign a commission rate to salespeople based on how much they sell. The rates work in \"tiers\" or brackets:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>$0 - $999 gets 0%<\/li>\n\n\n\n<li>$1,000 - $4,999 gets 5%<\/li>\n\n\n\n<li>$5,000 - $9,999 gets 10%<\/li>\n\n\n\n<li>$10,000+ gets 15%<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 1:&nbsp;<\/strong><\/p>\n\n\n\n<p>Set up your Data (Must be Sorted)<\/p>\n\n\n\n<p>For an approximate match to work, the first row must be sorted from smallest to largest.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-211.png\"><img decoding=\"async\" width=\"843\" height=\"199\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-211.png\" alt=\"\" class=\"wp-image-113514\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-211.png 843w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-211-300x71.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-211-768x181.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-211-150x35.png 150w\" sizes=\"(max-width: 843px) 100vw, 843px\" \/><\/figure>\n\n\n\n<p><strong>Step 2:<\/strong><br>A salesperson made $2,500 in sales. You want to find their rate and to get that enter this formula:<\/p>\n\n\n\n<p>=HLOOKUP(2500, B1:E2, 2, TRUE)<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-205.png\"><img decoding=\"async\" width=\"839\" height=\"255\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-205.png\" alt=\"\" class=\"wp-image-113509\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-205.png 839w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-205-300x91.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-205-768x233.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-205-150x46.png 150w\" sizes=\"(max-width: 839px) 100vw, 839px\" \/><\/figure>\n\n\n\n<p><strong>Step 4: <\/strong>The result will be 5%.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-203.png\"><img decoding=\"async\" width=\"840\" height=\"195\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-203.png\" alt=\"\" class=\"wp-image-113506\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-203.png 840w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-203-300x70.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-203-768x178.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-203-150x35.png 150w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/figure>\n\n\n\n<p><strong>The Logic<\/strong>:<\/p>\n\n\n\n<p><strong>1. The Rule:<\/strong> When TRUE is used, Excel searches for the <strong>largest value that is less than or equal to<\/strong> your lookup value (2500).<\/p>\n\n\n\n<p><strong>2. Compare:<\/strong> Excel compares 2500 against the sorted header row. It determines that 2500 is greater than 1000, but smaller than the next threshold (5000).<\/p>\n\n\n\n<p><strong>3. Match:<\/strong> Because it hasn't reached 5000 yet, Excel falls back to the previous largest match, which is <strong>1000<\/strong>, and returns the commission rate associated with that column (5%).<\/p>\n\n\n\n<p><strong>4. What if the data isn't sorted?<\/strong><br>If your sales thresholds were mixed up (e.g., 5000, then 1000, then 0), HLOOKUP would get confused and likely return a wrong commission rate or an error. This is why <strong>ascending order<\/strong> is mandatory for approximate matches.<\/p>\n\n\n\n<p><strong>Rule for Learners<\/strong><\/p>\n\n\n\n<p>If you use TRUE (or leave the last part blank), you <strong>must sort your first row in ascending order<\/strong> (0, 1000, 5000). If the row is mixed up (e.g., 5000, 0, 1000), Excel will give you a wrong answer or an error.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"common-mistakes-and-troubleshooting-in-hlookup\"><strong>Common Mistakes and Troubleshooting in HLOOKUP<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-mixing-up-row-and-column-orientation\"><strong>1. Mixing Up Row and Column Orientation<\/strong><\/h3>\n\n\n\n<p><strong>Issue<\/strong>:<br>Users often confuse HLOOKUP with VLOOKUP. HLOOKUP searches <strong>horizontally<\/strong> in the <strong>first row<\/strong> of a table, not vertically.<\/p>\n\n\n\n<p><strong>Example Mistake<\/strong>: Trying to search for a value in the first column using HLOOKUP:<\/p>\n\n\n\n<p>=HLOOKUP(\"Math\", A1:A5, 2, FALSE) \u2192 Incorrect (should be VLOOKUP)<\/p>\n\n\n\n<p><strong>Fix<\/strong>:<br>Ensure your lookup value is in the <strong>first row<\/strong>, and the data to be returned is in <strong>rows below<\/strong> it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-forgetting-to-use-false-for-exact-matches\"><strong>2. Forgetting to Use FALSE for Exact Matches<\/strong><\/h3>\n\n\n\n<p><strong>Issue<\/strong>:<br>By default, HLOOKUP uses <strong>approximate match (TRUE)<\/strong> if the fourth argument is omitted, which can return <strong>inaccurate results<\/strong>.<\/p>\n\n\n\n<p><strong>Example Mistake<\/strong>:<\/p>\n\n\n\n<p>=HLOOKUP(\"Alice\", A1:D2, 2) \u2192 Might return the wrong value<\/p>\n\n\n\n<p><strong>Fix<\/strong>:<br>Always use FALSE for an exact match unless you're intentionally using an approximate match:<\/p>\n\n\n\n<p>=HLOOKUP(\"Alice\", A1:D2, 2, FALSE)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-not-sorting-the-first-row-when-using-approximate-match\"><strong>3. Not Sorting the First Row When Using Approximate Match<\/strong><\/h3>\n\n\n\n<p><strong>Issue<\/strong>:<br>When using TRUE (Approximate Match), HLOOKUP assumes your data is organized from smallest to largest.&nbsp;<\/p>\n\n\n\n<p>It stops at the value closest to your lookup value without going over. If the row isn't sorted, HLOOKUP might return the wrong data, either too early or too late.<\/p>\n\n\n\n<p><strong>Example Mistake<\/strong>:<\/p>\n\n\n\n<p>=HLOOKUP(82, A1:D2, 2, TRUE) \u2192 Incorrect if A1:D1 isn\u2019t sorted numerically<\/p>\n\n\n\n<p><strong>Fix<\/strong>:<br>Always sort the first row in ascending order (smallest to largest) when using an approximate match (TRUE).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sort: 0, 50, 70, 90<\/li>\n\n\n\n<li>Then use: =HLOOKUP(82, A1:D2, 2, TRUE)<\/li>\n\n\n\n<li>Result<em>:<\/em> Excel will stop at <strong>70<\/strong> (because 82 is larger than 70 but smaller than 90) and return the corresponding value.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4-dealing-with-n-a-errors-and-how-to-resolve-them\"><strong>4. Dealing with #N\/A Errors and How to Resolve Them<\/strong><\/h3>\n\n\n\n<p><strong>Issue<\/strong>:<br>HLOOKUP returns #N\/A when:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The lookup value isn\u2019t found.<\/li>\n\n\n\n<li>You use FALSE, but the exact match doesn\u2019t exist.<\/li>\n\n\n\n<li>You reference a row number that doesn\u2019t exist in the table range.<\/li>\n<\/ul>\n\n\n\n<p><strong>Fixes<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Double-check spelling or spacing of the lookup value.<\/li>\n\n\n\n<li>Make sure the row_index_num is within the table range.<\/li>\n\n\n\n<li>Use IFERROR() to handle errors gracefully:<\/li>\n<\/ul>\n\n\n\n<p>=IFERROR(HLOOKUP(\"David\", A1:D2, 2, FALSE), \"Not Found\")<\/p>\n\n\n\n<p>By keeping these common issues in check, you'll ensure your HLOOKUP formulas return accurate and reliable results.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"hlookup-vs-vlookup-when-to-use-each\">HLOOKUP vs. VLOOKUP: When to Use Each<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Feature \/ Criteria<\/strong><\/td><td><strong>HLOOKUP<\/strong><\/td><td><strong>VLOOKUP<\/strong><\/td><\/tr><tr><td><strong>Function Name<\/strong><\/td><td>Horizontal Lookup<\/td><td>Vertical Lookup<\/td><\/tr><tr><td><strong>Data Orientation<\/strong><\/td><td>Works across <strong>rows<\/strong> (horizontal layout)<\/td><td>Works down <strong>columns<\/strong> (vertical layout)<\/td><\/tr><tr><td><strong>Lookup Direction<\/strong><\/td><td>Searches the first row and returns a value in the same column from a specified row number.<\/td><td>Searches the <strong>first column<\/strong> and returns from the right<\/td><\/tr><tr><td><strong>Syntax<\/strong><\/td><td>=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])<\/td><td>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/td><\/tr><tr><td><strong>Use Case Example<\/strong><\/td><td>Finding marks of subjects listed across a row<\/td><td>Finding employee details listed in a column<\/td><\/tr><tr><td><strong>Index Parameter<\/strong><\/td><td>row_index_num<\/td><td>col_index_num<\/td><\/tr><tr><td><strong>Data Requirement<\/strong><\/td><td>Lookup value must be in the <strong>first row<\/strong> of the range<\/td><td>Lookup value must be in the <strong>first column<\/strong> of the range<\/td><\/tr><tr><td><strong>Ease of Use<\/strong><\/td><td>Less commonly used; suitable for wide tables<\/td><td>More commonly used, suitable for tall tables<\/td><\/tr><tr><td><strong>Common Mistake<\/strong><\/td><td>Using it for column-wise data<\/td><td>Using it for row-wise data<\/td><\/tr><tr><td><strong>Example<\/strong><\/td><td>=HLOOKUP(\"Math\", A1:E3, 2, FALSE)<\/td><td>=VLOOKUP(\"John\", A1:C5, 2, FALSE)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Learn:<\/strong> <a href=\"https:\/\/www.mygreatlearning.com\/blog\/how-to-use-vlookup\/\">How To Use the VLookup Function in Excel?<\/a><\/p>\n\n\n\n<p><strong>Important: <\/strong>Look at where your headers (titles) are located:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Headers on Top?<\/strong> Then use <strong>HLOOKUP<\/strong> (Horizontal)<\/li>\n\n\n\n<li><strong>Headers on the Left?<\/strong> Then use <strong>VLOOKUP<\/strong> (Vertical)<\/li>\n<\/ul>\n\n\n\n<p>The HLOOKUP function is a quick way to find information stored in rows, helping you locate the data you need without manual searching.&nbsp;<\/p>\n\n\n\n<p>To improve your overall Excel skills and learn how to use formulas like HLOOKUP more confidently, Great Learning\u2019s <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\">Data Analytics in Excel course<\/a> offers practical, step-by-step training that helps you work smarter with data in any role.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to use Excel's HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.<\/p>\n","protected":false},"author":41,"featured_media":113519,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[9],"tags":[36822],"content_type":[],"class_list":["post-113501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","tag-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Use the HLOOKUP Function in Excel?<\/title>\n<meta name=\"description\" content=\"Learn how to use Excel&#039;s HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use the HLOOKUP Function in Excel?\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Excel&#039;s HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Great Learning Blog: Free Resources what Matters to shape your Career!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GreatLearningOfficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-24T13:23:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1408\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Great Learning Editorial Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/Great_Learning\" \/>\n<meta name=\"twitter:site\" content=\"@Great_Learning\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Great Learning Editorial Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/\"},\"author\":{\"name\":\"Great Learning Editorial Team\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\"},\"headline\":\"How to Use the HLOOKUP Function in Excel?\",\"datePublished\":\"2025-11-24T13:23:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/\"},\"wordCount\":1928,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/hlookup-excel.webp\",\"keywords\":[\"excel\"],\"articleSection\":[\"Data Science and Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/\",\"name\":\"How to Use the HLOOKUP Function in Excel?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/hlookup-excel.webp\",\"datePublished\":\"2025-11-24T13:23:14+00:00\",\"description\":\"Learn how to use Excel's HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/hlookup-excel.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/hlookup-excel.webp\",\"width\":1408,\"height\":768,\"caption\":\"HLOOKUP Function in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/hlookup-function-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Science and Analytics\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/data-science\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Use the HLOOKUP Function in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"name\":\"Great Learning Blog\",\"description\":\"Learn, Upskill &amp; Career Development Guide and Resources\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"alternateName\":\"Great Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\",\"name\":\"Great Learning\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"width\":900,\"height\":900,\"caption\":\"Great Learning\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/GreatLearningOfficial\\\/\",\"https:\\\/\\\/x.com\\\/Great_Learning\",\"https:\\\/\\\/www.instagram.com\\\/greatlearningofficial\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/in.pinterest.com\\\/greatlearning12\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/beaconelearning\\\/\"],\"description\":\"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.\",\"email\":\"info@mygreatlearning.com\",\"legalName\":\"Great Learning Education Services Pvt. Ltd\",\"foundingDate\":\"2013-11-29\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\",\"name\":\"Great Learning Editorial Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"caption\":\"Great Learning Editorial Team\"},\"description\":\"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.\",\"sameAs\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/\",\"https:\\\/\\\/in.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/Great_Learning\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCObs0kLIrDjX2LLSybqNaEA\"],\"award\":[\"Best EdTech Company of the Year 2024\",\"Education Economictimes Outstanding Education\\\/Edtech Solution Provider of the Year 2024\",\"Leading E-learning Platform 2024\"],\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/author\\\/greatlearning\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Use the HLOOKUP Function in Excel?","description":"Learn how to use Excel's HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Use the HLOOKUP Function in Excel?","og_description":"Learn how to use Excel's HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.","og_url":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/","og_site_name":"Great Learning Blog: Free Resources what Matters to shape your Career!","article_publisher":"https:\/\/www.facebook.com\/GreatLearningOfficial\/","article_published_time":"2025-11-24T13:23:14+00:00","og_image":[{"width":1408,"height":768,"url":"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp","type":"image\/webp"}],"author":"Great Learning Editorial Team","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/Great_Learning","twitter_site":"@Great_Learning","twitter_misc":{"Written by":"Great Learning Editorial Team","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/"},"author":{"name":"Great Learning Editorial Team","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad"},"headline":"How to Use the HLOOKUP Function in Excel?","datePublished":"2025-11-24T13:23:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/"},"wordCount":1928,"publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp","keywords":["excel"],"articleSection":["Data Science and Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/","url":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/","name":"How to Use the HLOOKUP Function in Excel?","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp","datePublished":"2025-11-24T13:23:14+00:00","description":"Learn how to use Excel's HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.","breadcrumb":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/#primaryimage","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp","width":1408,"height":768,"caption":"HLOOKUP Function in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mygreatlearning.com\/blog\/hlookup-function-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.mygreatlearning.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Science and Analytics","item":"https:\/\/www.mygreatlearning.com\/blog\/data-science\/"},{"@type":"ListItem","position":3,"name":"How to Use the HLOOKUP Function in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.mygreatlearning.com\/blog\/#website","url":"https:\/\/www.mygreatlearning.com\/blog\/","name":"Great Learning Blog","description":"Learn, Upskill &amp; Career Development Guide and Resources","publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"alternateName":"Great Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mygreatlearning.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization","name":"Great Learning","url":"https:\/\/www.mygreatlearning.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","width":900,"height":900,"caption":"Great Learning"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/GreatLearningOfficial\/","https:\/\/x.com\/Great_Learning","https:\/\/www.instagram.com\/greatlearningofficial\/","https:\/\/www.linkedin.com\/school\/great-learning\/","https:\/\/in.pinterest.com\/greatlearning12\/","https:\/\/www.youtube.com\/user\/beaconelearning\/"],"description":"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.","email":"info@mygreatlearning.com","legalName":"Great Learning Education Services Pvt. Ltd","foundingDate":"2013-11-29","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad","name":"Great Learning Editorial Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","caption":"Great Learning Editorial Team"},"description":"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.","sameAs":["https:\/\/www.mygreatlearning.com\/","https:\/\/in.linkedin.com\/school\/great-learning\/","https:\/\/x.com\/https:\/\/twitter.com\/Great_Learning","https:\/\/www.youtube.com\/channel\/UCObs0kLIrDjX2LLSybqNaEA"],"award":["Best EdTech Company of the Year 2024","Education Economictimes Outstanding Education\/Edtech Solution Provider of the Year 2024","Leading E-learning Platform 2024"],"url":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp",1408,768,false],"thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel-150x150.webp",150,150,true],"medium":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel-300x164.webp",300,164,true],"medium_large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel-768x419.webp",768,419,true],"large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel-1024x559.webp",1024,559,true],"1536x1536":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp",1408,768,false],"2048x2048":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel.webp",1408,768,false],"web-stories-poster-portrait":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel-640x768.webp",640,768,true],"web-stories-publisher-logo":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel-96x96.webp",96,96,true],"web-stories-thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/hlookup-excel-150x82.webp",150,82,true]},"uagb_author_info":{"display_name":"Great Learning Editorial Team","author_link":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"},"uagb_comment_info":0,"uagb_excerpt":"Learn how to use Excel's HLOOKUP function to search horizontally in rows and retrieve exact or approximate data with clear examples and step-by-step instructions.","_links":{"self":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/113501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/comments?post=113501"}],"version-history":[{"count":3,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/113501\/revisions"}],"predecessor-version":[{"id":113520,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/113501\/revisions\/113520"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media\/113519"}],"wp:attachment":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media?parent=113501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/categories?post=113501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/tags?post=113501"},{"taxonomy":"content_type","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/content_type?post=113501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}