{"id":717,"date":"2019-04-18T17:39:49","date_gmt":"2019-04-18T14:39:49","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=717"},"modified":"2019-04-18T17:43:17","modified_gmt":"2019-04-18T14:43:17","slug":"the-hlookup-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-hlookup-function\/","title":{"rendered":"The HLOOKUP Function"},"content":{"rendered":"\n<p>Use <strong>HLOOKUP <\/strong>when you need to find things in a table or a range by column. It is part of the lookup and reference functions of Excel . <\/p>\n\n\n\n<p>We have prepared a<strong> <a href=\"https:\/\/www.test4u.eu\/excelpedia\/how-to-use-the-hlookup-function\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"tutorial on the HLOOKUP (opens in a new tab)\">tutorial on the HLOOKUP<\/a><\/strong> function to explain it in a bit more detail.<\/p>\n\n\n\n<p>\n\nThe syntax of the function is the following:\n\n<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-large is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>HLOOKUP<\/strong><em>(<\/em><strong>lookup_value<\/strong><em>, <\/em><strong>lookup_array<\/strong><em>, <\/em><strong>row_num<\/strong><em>, [<\/em><strong>match_type<\/strong><em>])<\/em>  <\/p><cite><strong>lookup_value<\/strong> : The value that you want to match in lookup_array.<br><span><b>lookup_array<\/b><\/span> : The range of cells being searched. <br><strong>row_num<\/strong>: The row number containing the return value<br><strong>match_type<\/strong>: Optional. The number 0 (FALSE=Exact Match), or 1 (TRUE=Approximate Match) which is the default value .  <\/cite><\/blockquote>\n\n\n\n<p> The lookup value should always be in the first row in the range for HLOOKUP to work correctly. <\/p>\n\n\n\n<p>You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click on the button to practice using this function, with the help of our <strong>Online Assessment Tool<\/strong>:<\/p>\n\n\n<p class=\"button-practice-container\" ><a class=\"button button-primary button-practice\" style=\"height:auto\"  href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/plugins\/unlimited-integration\/run.php?id=NVJBNWlaUENhbkhVTEQ4OS9xamNqUXZDV0Rad3pGOThOM2hsSlZmYjFreEpGMUZzYUhIcENhWmhmSWJtT2JpYjUyNnY0NGN5QzhFT25KMUtYNDk3MWc9PQ==&b=bkNNRXpMUjdYc0MyOGZIY0M0QmpoZFhSdFQ4Q1MwSDM2eXRsV3RMSDZoQ3c3WW9hMVpHSDAvQ1VKaUxLWm9sS2NPUHNPaFp0eDc5V1M4ekg0UXl1ZS9vR0JzZlFkSjQ5cFBvTzdmd1ZoOUk9\">Practice<\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<p class=\"has-medium-font-size\"><strong>Here is an example of how to use the HLOOKUP function:<\/strong><\/p>\n\n\n\n<p>Display the representative of the Della company in the cell B8 of the hlookup workbook using the hlookup function. Representatives of companies are displayed in the SALES worksheet. Then reproduce the function up to the cell G8.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/DfmnfC_6i60?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Use HLOOKUP when you need to find things in a table or a range by column. It is part of the lookup and reference functions of Excel . <\/p>\n","protected":false},"author":2,"featured_media":578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[54,49,32],"class_list":["post-717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-hlookup","tag-lookup-functions","tag-reference"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/hlookup.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-bz","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=717"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/578"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}