{"id":1342,"date":"2018-07-04T10:31:55","date_gmt":"2018-07-04T10:31:55","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1342"},"modified":"2023-11-03T09:07:58","modified_gmt":"2023-11-03T09:07:58","slug":"hlookup","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/hlookup\/","title":{"rendered":"HLOOKUP function"},"content":{"rendered":"\n
The HLOOKUP function in Excel is used to search for a value in the header row of a table and return a corresponding value from the row below. It’s like looking up a word in a dictionary and finding its definition.<\/p>\n\n\n\n
Here are the arguments you can use with the HLOOKUP function:<\/p>\n\n\n\n Let’s understand how to use the HLOOKUP function with some examples:<\/p>\n\n\n\n Example 1:<\/strong><\/p>\n\n\n\n Suppose you have a table of student grades, and you want to find the grade for a student named “Alice.” You can use the HLOOKUP function like this:<\/p>\n\n\n\n This formula searches for “Alice” in the header row (A1 to E1), and when it finds her, it returns her grade from row 2 (A2 to E2).<\/p>\n\n\n\n Example 2:<\/strong><\/p>\n\n\n\n If you want to find an approximate match, say you want to find the grade of a student whose name is alphabetically between “Alex” and “Bob,” you can use a range_lookup of TRUE or omit it, like this:<\/p>\n\n\n\n The function will find the closest match and return the corresponding grade.<\/p>\n\n\n\n Example 3:<\/strong><\/p>\n\n\n\n If the header row is not sorted in ascending order, you can still use HLOOKUP to find a value. It will return the first match it finds in the header row.<\/p>\n\n\n\n Even if the names are not in order, it will find “Alice” in the header row and return her grade.<\/p>\n\n\n\n Example 4:<\/strong><\/p>\n\n\n\n Remember that HLOOKUP searches only in the header row and returns a value from the specified row. If it doesn’t find the value, it returns an error (#N\/A). So, make sure your lookup value is present in the header row.<\/p>\n\n\n\n If “David” is not in the header row, this formula will result in an error.<\/p>\n\n\n\n It’s essential to understand the use of HLOOKUP when dealing with data organized in tables with headers, as it helps you quickly find and retrieve specific information based on a lookup value.<\/p>\n","protected":false},"excerpt":{"rendered":" The HLOOKUP function in Excel is used to search for a value in the header row of a table and return a corresponding…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nHLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])<\/strong><\/code><\/p>\n\n\n\n
Arguments<\/h2>\n\n\n\n
lookup_value<\/strong><\/td> The value you want to find in the header row of the table.<\/td><\/tr> table_array<\/strong><\/td> The range that contains the data you want to search in, including the header row.<\/td><\/tr> row_index_num<\/strong><\/td> The row number from which you want to return the data (counting from the top row of the table as 1).<\/td><\/tr> [range_lookup]<\/strong><\/td> (Optional) A logical value that indicates whether you want an exact or approximate match. If TRUE or omitted, it looks for an approximate match; if FALSE, it looks for an exact match.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
=HLOOKUP(\"Alice\", A1:E5, 2, FALSE)<\/code><\/pre>\n\n\n\n
=HLOOKUP(\"Charlie\", A1:E5, 2, TRUE)<\/code><\/pre>\n\n\n\n
=HLOOKUP(\"Alice\", A1:E5, 2, FALSE)<\/code><\/pre>\n\n\n\n
=HLOOKUP(\"David\", A1:E5, 2, FALSE)<\/code><\/pre>\n\n\n\n
Additional Information<\/h2>\n\n\n\n