{"id":720,"date":"2019-04-18T17:32:21","date_gmt":"2019-04-18T14:32:21","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=720"},"modified":"2019-04-19T16:54:47","modified_gmt":"2019-04-19T13:54:47","slug":"the-vlookup-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-vlookup-function\/","title":{"rendered":"The VLOOKUP Function"},"content":{"rendered":"\n<p>Use VLOOKUP when you need to find things in a table or a range by row. 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-vlookup-function\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"tutorial on the VLOOKUP (opens in a new tab)\">tutorial on the VLOOKUP<\/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>VLOOKUP<\/strong>(<strong>lookup_value<\/strong>, <strong>lookup_array<\/strong>, <strong>col_num<\/strong>, [<strong>match_type<\/strong>]) <\/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>col_num<\/strong>: The column 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 column of the range for VLOOKUP to work correctly.<\/p>\n\n\n\n<p>\n\nYou 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.\n\n<\/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=WXBDdkxpYmNiZWJKcUNYL1JNdGttRUZHNTBTTGt1N0FtcUNrZDhWVlJqRXpteExLRU5jMUU3VThuOFArQ0I1clR6K1ZBT0dVSlV5UVNTRU1lRVZTZ3c9PQ==&b=Wng0QkhaZkhLb2xYbHdxaUNOZjRQZDk4ejRCeFJWTElPUmlnbUtxNnVDdTQzdzFNbFhwOHRrank1UUxsWmFndkNCaG1qTC9YK3JBRkNES21KaHpkQzZNU0VBbW1OSE9IVnBFSXR0SGpHZzA9\">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 are some examples of how to use the VLOOKUP function:<\/strong><\/p>\n\n\n\n<p>Display the sales of the Della company in the cell \u03928 of the vlookup worksheet, with the use of the function vlookup. You will find the sales of the company in the SALES worksheet. Then reproduce the function up to the cell B12.<\/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\/qqFo6ht2-Wg?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\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>The cell range G3:H8 displays teams and countries of origin. Insert a function in the cell D2 to return the country name for the specific team. Then, reproduce the function in the cell range D3:D21.<\/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\/Wzsrwc_T-FI?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\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Navigate to the cell C2 and create a function that returns the respective Name of singer appearing in the cell range A18:B20.<\/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\/bwxuUP98JWM?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 VLOOKUP when you need to find things in a table or a range by row. It is part of the lookup and reference functions of Excel.<\/p>\n","protected":false},"author":2,"featured_media":575,"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":[49,32,53],"class_list":["post-720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-lookup-functions","tag-reference","tag-vlookup"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/vlookup.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-bC","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/720","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=720"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/575"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}