{"id":2843,"date":"2018-08-08T11:28:24","date_gmt":"2018-08-08T11:28:24","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=2843"},"modified":"2024-03-29T13:51:58","modified_gmt":"2024-03-29T13:51:58","slug":"check-if-value-exists-in-another-column","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/","title":{"rendered":"Check if Value Exists in Another Column Using VLOOKUP"},"content":{"rendered":"\n<p>In order to get the value from the cell next to the matching cell, you have to use the vlookup function. This function will look for the value in the specified range and return the value from the chosen column.<\/p>\n\n\n\n<p>In the following example, there is a list of weekdays from Monday to Sunday and their position.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"430\" height=\"200\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png\" alt=\"\" class=\"wp-image-2848\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png 430w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column-300x140.png 300w\" sizes=\"(max-width: 430px) 100vw, 430px\" \/><\/figure>\n\n\n\n<p>Enter the following code into cell D2 and <a href=\"https:\/\/officetuts.net\/excel\/training\/autofill\/\">autofill<\/a> the rest of the cell in the column.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=VLOOKUP(A2, B:C, 2, FALSE)<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"429\" height=\"200\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/autofill-cells.png\" alt=\"\" class=\"wp-image-2847\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/autofill-cells.png 429w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/autofill-cells-300x140.png 300w\" sizes=\"(max-width: 429px) 100vw, 429px\" \/><\/figure>\n\n\n\n<p>Let\u2019s analyze the code.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"245\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/analyze-the-code.png\" alt=\"\" class=\"wp-image-2846\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/analyze-the-code.png 494w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/analyze-the-code-300x149.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>The first occurrence of Monday in Col 2 is in cell B5. Next to Monday is 4. And this <a href=\"https:\/\/officetuts.net\/excel\/examples\/count-how-many-times-a-value-appears-in-cell-or-column\/\">value is in cell<\/a> D2.<\/p>\n\n\n\n<p>Two cells in column D resulted in the <strong>#N\/A<\/strong> error. If you look closer, you will notice that it happens for Wednesday and Friday. As you can see, they are not present in Col 2.<\/p>\n\n\n\n<p>If you want to beautify the code and get rid of these errors, modify the code.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IFERROR(VLOOKUP(A2, B:C, 2, FALSE), \"no match\")<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"429\" height=\"200\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/modified-code.png\" alt=\"\" class=\"wp-image-2845\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/modified-code.png 429w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/modified-code-300x140.png 300w\" sizes=\"(max-width: 429px) 100vw, 429px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In order to get the value from the cell next to the matching cell, you have to use the vlookup function. This function&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Check if Value Exists in Another Column Using VLOOKUP<\/title>\n<meta name=\"description\" content=\"Learn how to use vlookup function in Excel to get the value from the cell next to the matching cell. Example provided for step-by-step guidance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Check if Value Exists in Another Column Using VLOOKUP\" \/>\n<meta property=\"og:description\" content=\"Learn how to use vlookup function in Excel to get the value from the cell next to the matching cell. Example provided for step-by-step guidance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-08T11:28:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T13:51:58+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Check if Value Exists in Another Column Using VLOOKUP\",\"datePublished\":\"2018-08-08T11:28:24+00:00\",\"dateModified\":\"2024-03-29T13:51:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/\"},\"wordCount\":161,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/\",\"name\":\"Check if Value Exists in Another Column Using VLOOKUP\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png\",\"datePublished\":\"2018-08-08T11:28:24+00:00\",\"dateModified\":\"2024-03-29T13:51:58+00:00\",\"description\":\"Learn how to use vlookup function in Excel to get the value from the cell next to the matching cell. Example provided for step-by-step guidance.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Check if Value Exists in Another Column Using VLOOKUP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Check if Value Exists in Another Column Using VLOOKUP","description":"Learn how to use vlookup function in Excel to get the value from the cell next to the matching cell. Example provided for step-by-step guidance.","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:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/","og_locale":"en_US","og_type":"article","og_title":"Check if Value Exists in Another Column Using VLOOKUP","og_description":"Learn how to use vlookup function in Excel to get the value from the cell next to the matching cell. Example provided for step-by-step guidance.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/","article_published_time":"2018-08-08T11:28:24+00:00","article_modified_time":"2024-03-29T13:51:58+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Check if Value Exists in Another Column Using VLOOKUP","datePublished":"2018-08-08T11:28:24+00:00","dateModified":"2024-03-29T13:51:58+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/"},"wordCount":161,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png","keywords":["pinterest"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/","url":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/","name":"Check if Value Exists in Another Column Using VLOOKUP","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png","datePublished":"2018-08-08T11:28:24+00:00","dateModified":"2024-03-29T13:51:58+00:00","description":"Learn how to use vlookup function in Excel to get the value from the cell next to the matching cell. Example provided for step-by-step guidance.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/08\/example-check-if-value-exists-in-another-column.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-value-exists-in-another-column\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Check if Value Exists in Another Column Using VLOOKUP"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/2843"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=2843"}],"version-history":[{"count":7,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/2843\/revisions"}],"predecessor-version":[{"id":13180,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/2843\/revisions\/13180"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=2843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=2843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=2843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}