{"id":277,"date":"2022-11-01T07:50:45","date_gmt":"2022-11-01T07:50:45","guid":{"rendered":"https:\/\/jassweb.com\/new22\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed\/"},"modified":"2022-11-01T07:50:45","modified_gmt":"2022-11-01T07:50:45","slug":"solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/","title":{"rendered":"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed]"},"content":{"rendered":"<h2> Introduction <\/h2>\n<p>[ad_1]<\/p>\n<p>VBA is a powerful tool for automating tasks in Microsoft Excel. One of the most useful functions in VBA is the VLookup function, which allows you to quickly look up a value in a table and enter it into a cell. In this article, we will discuss how to use the VLookup function in VBA to enter a value into a cell. We will also discuss some tips and tricks for using VLookup in VBA.<\/p>\n<h2> Solution<\/h2>\n<p><\/p>\n<p>Sub vlookup_example()<\/p>\n<p>Dim ws As Worksheet<br \/>\nDim rng As Range<br \/>\nDim lookup_value As Variant<br \/>\nDim lookup_range As Range<br \/>\nDim lookup_column As Long<br \/>\nDim lookup_result As Variant<\/p>\n<p>Set ws = ThisWorkbook.Sheets(&#8220;Sheet1&#8221;)<br \/>\nSet rng = ws.Range(&#8220;A1&#8221;)<br \/>\nlookup_value = rng.Value<br \/>\nSet lookup_range = ws.Range(&#8220;A2:B10&#8221;)<br \/>\nlookup_column = 2<\/p>\n<p>lookup_result = Application.WorksheetFunction.VLookup(lookup_value, lookup_range, lookup_column, False)<\/p>\n<p>rng.Offset(0, 1).Value = lookup_result<\/p>\n<p>End Sub <\/p>\n<p><\/p>\n<div class=\"entry-content\" itemprop=\"text\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/p>\n<p><\/p>\n<div id=\"answer-47818156\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"47818156\" data-parentid=\"47817938\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<pre><code>Sub MyReplace()\nDim rw As Long\nWith ActiveSheet\n    On Error Resume Next\n        rw = Application.WorksheetFunction.Match(.Range(\"B13\"), .Range(\"B4:B7\"), 0)\n    On Error GoTo 0\n    If rw &gt; 0 Then\n        .Range(\"C\" &amp; rw + .Range(\"B4:B7\").Row - 1).Value = .Range(\"C13\")\n    Else\n        MsgBox \"Name not found in range\"\n    End If\nEnd With\nEnd Sub\n<\/code><\/pre>\n<\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p> <span class=\"d-none\" itemprop=\"commentCount\">6<\/span> <\/p>\n<\/div>\n<\/div>\n<p>solved How do I use vlookup in VBA to enter a value into that cell [closed] <\/p>\n<p><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/div>\n<p>[ad_2]<\/p>\n<p>Using VBA to enter a value into a cell using VLOOKUP is a relatively simple process. The first step is to define the range of cells that you want to search. This can be done by using the Range object. For example, if you wanted to search the range A1:B10, you would use the following code:<\/p>\n<pre><code>Dim rng As Range\nSet rng = Range(\"A1:B10\")\n<\/code><\/pre>\n<p>Once the range is defined, you can use the VLOOKUP function to search the range for a specific value. The syntax for the VLOOKUP function is as follows:<\/p>\n<pre><code>VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\n<\/code><\/pre>\n<p>The lookup_value is the value that you are searching for. The table_array is the range of cells that you are searching. The col_index_num is the column number of the value that you want to return. The range_lookup is an optional argument that specifies whether you want an exact match or an approximate match. If you leave this argument blank, it will default to an approximate match.<\/p>\n<p>Once you have the VLOOKUP function set up, you can use it to enter a value into a cell. For example, if you wanted to enter the value &#8220;foo&#8221; into cell C1, you would use the following code:<\/p>\n<pre><code>Range(\"C1\").Value = Application.WorksheetFunction.VLookup(\"foo\", rng, 2, False)\n<\/code><\/pre>\n<p>The above code will search the range A1:B10 for the value &#8220;foo&#8221; and return the value in the second column of the range. This value will then be entered into cell C1.<\/p>\n<p>Using VBA to enter a value into a cell using VLOOKUP is a simple process that can save you time and effort. With a few lines of code, you can quickly search a range of cells and enter a value into a cell.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction [ad_1] VBA is a powerful tool for automating tasks in Microsoft Excel. One of the most useful functions in VBA is the VLookup function, which allows you to quickly look up a value in a table and enter it into a cell. In this article, we will discuss how to use the VLookup function &#8230; <a title=\"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\" aria-label=\"More on [Solved] How do I use vlookup in VBA to enter a value into that cell [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[400,401],"class_list":["post-277","post","type-post","status-publish","format-standard","hentry","category-solved","tag-excel","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How do I use vlookup in VBA to enter a value into that cell [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"Introduction [ad_1] VBA is a powerful tool for automating tasks in Microsoft Excel. One of the most useful functions in VBA is the VLookup function, which allows you to quickly look up a value in a table and enter it into a cell. In this article, we will discuss how to use the VLookup function ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-01T07:50:45+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed]\",\"datePublished\":\"2022-11-01T07:50:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\"},\"wordCount\":454,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"excel\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\",\"name\":\"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-01T07:50:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed] - JassWeb","og_description":"Introduction [ad_1] VBA is a powerful tool for automating tasks in Microsoft Excel. One of the most useful functions in VBA is the VLookup function, which allows you to quickly look up a value in a table and enter it into a cell. In this article, we will discuss how to use the VLookup function ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/","og_site_name":"JassWeb","article_published_time":"2022-11-01T07:50:45+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed]","datePublished":"2022-11-01T07:50:45+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/"},"wordCount":454,"commentCount":0,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["excel","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/","url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/","name":"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-01T07:50:45+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-vlookup-in-vba-to-enter-a-value-into-that-cell-closed-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How do I use vlookup in VBA to enter a value into that cell [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=277"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/277\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}