{"id":256083,"date":"2024-06-14T13:26:49","date_gmt":"2024-06-14T13:26:49","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=256083"},"modified":"2024-06-14T13:26:49","modified_gmt":"2024-06-14T13:26:49","slug":"how-to-bring-a-specific-value-when-doing-vlookup","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/","title":{"rendered":"How to bring a specific value when doing VLOOKUP?"},"content":{"rendered":"<p>VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a different column within the same table. However, when using VLOOKUP, you might encounter situations where you need to bring a specific value instead of the respective lookup value. In this article, we will explore different approaches to achieving this requirement.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Using_VLOOKUP_with_TRUE_as_the_fourth_argument\" title=\"Using VLOOKUP with TRUE as the fourth argument\">Using VLOOKUP with TRUE as the fourth argument<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Using_CHOOSE_Function_along_with_VLOOKUP\" title=\"**Using CHOOSE Function along with VLOOKUP**\">**Using CHOOSE Function along with VLOOKUP**<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q1_How_can_I_use_VLOOKUP_with_multiple_criteria\" title=\"Q1: How can I use VLOOKUP with multiple criteria?\">Q1: How can I use VLOOKUP with multiple criteria?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q2_Can_I_use_VLOOKUP_to_search_for_values_vertically_and_horizontally\" title=\"Q2: Can I use VLOOKUP to search for values vertically and horizontally?\">Q2: Can I use VLOOKUP to search for values vertically and horizontally?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q3_Is_it_possible_to_perform_VLOOKUP_between_different_sheets\" title=\"Q3: Is it possible to perform VLOOKUP between different sheets?\">Q3: Is it possible to perform VLOOKUP between different sheets?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q4_How_can_I_handle_errors_in_VLOOKUP\" title=\"Q4: How can I handle errors in VLOOKUP?\">Q4: How can I handle errors in VLOOKUP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q5_Can_VLOOKUP_work_with_text_values\" title=\"Q5: Can VLOOKUP work with text values?\">Q5: Can VLOOKUP work with text values?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q6_How_does_VLOOKUP_handle_duplicate_values_in_the_lookup_column\" title=\"Q6: How does VLOOKUP handle duplicate values in the lookup column?\">Q6: How does VLOOKUP handle duplicate values in the lookup column?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q7_What_happens_if_the_lookup_value_is_not_found_in_VLOOKUP\" title=\"Q7: What happens if the lookup value is not found in VLOOKUP?\">Q7: What happens if the lookup value is not found in VLOOKUP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q8_Does_VLOOKUP_consider_case_sensitivity_while_searching\" title=\"Q8: Does VLOOKUP consider case sensitivity while searching?\">Q8: Does VLOOKUP consider case sensitivity while searching?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q9_Can_I_use_wildcard_characters_in_VLOOKUP\" title=\"Q9: Can I use wildcard characters in VLOOKUP?\">Q9: Can I use wildcard characters in VLOOKUP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q10_Can_I_use_VLOOKUP_to_fetch_values_from_multiple_columns\" title=\"Q10: Can I use VLOOKUP to fetch values from multiple columns?\">Q10: Can I use VLOOKUP to fetch values from multiple columns?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q11_Is_there_an_alternative_to_VLOOKUP\" title=\"Q11: Is there an alternative to VLOOKUP?\">Q11: Is there an alternative to VLOOKUP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#Q12_Can_I_use_VLOOKUP_with_non-contiguous_ranges\" title=\"Q12: Can I use VLOOKUP with non-contiguous ranges?\">Q12: Can I use VLOOKUP with non-contiguous ranges?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Using_VLOOKUP_with_TRUE_as_the_fourth_argument\"><\/span>Using VLOOKUP with TRUE as the fourth argument<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By default, the fourth argument (range_lookup) in VLOOKUP is set to FALSE or 0, meaning an exact match is required. However, to bring a specific value rather than the lookup value, you need to change it to TRUE or 1. This argument enables approximate matching and enables you to fetch the desired value.<\/p>\n<p>Let&#8217;s consider an example. Suppose you have a table with employee names and their corresponding IDs. You want to display the employee ID associated with a specific employee name. Thus, your VLOOKUP formula would be: <\/p>\n<p><b>=VLOOKUP(&#8220;John&#8221;, A2:B10, 2, TRUE)<\/b><\/p>\n<p>Here, &#8220;John&#8221; is the lookup value, A2:B10 is the table range, 2 represents the second column where the desired value is located, and TRUE indicates that you want to allow approximate matching.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Using_CHOOSE_Function_along_with_VLOOKUP\"><\/span>**Using CHOOSE Function along with VLOOKUP**<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another way to bring a specific value when using VLOOKUP is by combining it with the CHOOSE function. The CHOOSE function allows you to select a value from a list based on a specified index. By employing CHOOSE along with VLOOKUP, you can fetch a value based on specific criteria, such as condition or position.<\/p>\n<p>Let&#8217;s illustrate this with an example. Assume you have a table with product names and their corresponding prices. You want to retrieve the price of a specific product by accessing its index position rather than the product name. In this case, the formula would be:<\/p>\n<p><b>=VLOOKUP(CHOOSE(2,A2:A6,B2:B6), A2:B6, 2, FALSE)<\/b><\/p>\n<p>In this formula, CHOOSE(2,A2:A6,B2:B6) will select the second value from A2:A6 (range of product names) and B2:B6 (range of prices), acting as the lookup value for VLOOKUP. FALSE as the last argument ensures an exact match.<\/p>\n<p>Now, let&#8217;s dive into some related FAQs regarding VLOOKUP:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Q1_How_can_I_use_VLOOKUP_with_multiple_criteria\"><\/span>Q1: How can I use VLOOKUP with multiple criteria?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A1: To use VLOOKUP with multiple criteria, you can concatenate the criteria values into a single cell and perform a lookup based on that cell.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q2_Can_I_use_VLOOKUP_to_search_for_values_vertically_and_horizontally\"><\/span>Q2: Can I use VLOOKUP to search for values vertically and horizontally?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A2: Yes, VLOOKUP can be used to search for values both vertically and horizontally. For horizontal lookup, you need to use the HLOOKUP function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q3_Is_it_possible_to_perform_VLOOKUP_between_different_sheets\"><\/span>Q3: Is it possible to perform VLOOKUP between different sheets?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A3: Yes, VLOOKUP can be used between different sheets by referencing the sheet name along with the range in the formula.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q4_How_can_I_handle_errors_in_VLOOKUP\"><\/span>Q4: How can I handle errors in VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A4: You can handle errors in VLOOKUP by using the IFERROR function, which allows you to replace error values with a custom message or alternative result.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q5_Can_VLOOKUP_work_with_text_values\"><\/span>Q5: Can VLOOKUP work with text values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A5: Yes, VLOOKUP can work with both numeric and text values. However, make sure that the data types in the lookup column and the lookup value match.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q6_How_does_VLOOKUP_handle_duplicate_values_in_the_lookup_column\"><\/span>Q6: How does VLOOKUP handle duplicate values in the lookup column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A6: VLOOKUP only returns the first match it encounters in case of duplicate values in the lookup column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q7_What_happens_if_the_lookup_value_is_not_found_in_VLOOKUP\"><\/span>Q7: What happens if the lookup value is not found in VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A7: If the lookup value is not found in VLOOKUP, it will return an error value, typically #N\/A. You can handle this using the IFERROR function, as mentioned earlier.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q8_Does_VLOOKUP_consider_case_sensitivity_while_searching\"><\/span>Q8: Does VLOOKUP consider case sensitivity while searching?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A8: No, by default, VLOOKUP does not consider case sensitivity while searching. To perform a case-sensitive lookup, you need to use the EXACT function in combination with VLOOKUP.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q9_Can_I_use_wildcard_characters_in_VLOOKUP\"><\/span>Q9: Can I use wildcard characters in VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A9: No, VLOOKUP does not support wildcard characters like *, ? in the lookup value. In such cases, you might need to use other functions like INDEX and MATCH or TEXTJOIN.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q10_Can_I_use_VLOOKUP_to_fetch_values_from_multiple_columns\"><\/span>Q10: Can I use VLOOKUP to fetch values from multiple columns?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A10: Yes, you can use VLOOKUP to fetch values from multiple columns by adjusting the column index number accordingly.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q11_Is_there_an_alternative_to_VLOOKUP\"><\/span>Q11: Is there an alternative to VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A11: Yes, there are alternatives to VLOOKUP, such as INDEX and MATCH functions, which provide more flexibility and advanced lookup capabilities.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q12_Can_I_use_VLOOKUP_with_non-contiguous_ranges\"><\/span>Q12: Can I use VLOOKUP with non-contiguous ranges?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>A12: No, VLOOKUP cannot be used with non-contiguous or disjointed ranges. The lookup range must be a single, contiguous area of cells.<\/p>\n<p>With the knowledge gained from this article and the answers to these FAQs, you can confidently use VLOOKUP in Excel to fetch specific values and handle various lookup scenarios. Remember to explore alternative functions as well, depending on the complexity of your data and requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a different column within the same table. However, when using VLOOKUP, you might encounter situations where you need to bring a specific value instead of the respective lookup value. In &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to bring a specific value when doing VLOOKUP?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#more-256083\">Read more<span class=\"screen-reader-text\">How to bring a specific value when doing VLOOKUP?<\/span><\/a><\/p>\n","protected":false},"author":65,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-256083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to bring a specific value when doing VLOOKUP?<\/title>\n<meta name=\"description\" content=\"VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to bring a specific value when doing VLOOKUP?\" \/>\n<meta property=\"og:description\" content=\"VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-14T13:26:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Timothy Mathis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Timothy Mathis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/\"},\"author\":{\"name\":\"Timothy Mathis\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318\"},\"headline\":\"How to bring a specific value when doing VLOOKUP?\",\"datePublished\":\"2024-06-14T13:26:49+00:00\",\"dateModified\":\"2024-06-14T13:26:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/\"},\"wordCount\":820,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/\",\"name\":\"How to bring a specific value when doing VLOOKUP?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-06-14T13:26:49+00:00\",\"dateModified\":\"2024-06-14T13:26:49+00:00\",\"description\":\"VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to bring a specific value when doing VLOOKUP?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318\",\"name\":\"Timothy Mathis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Timothy Mathis\"},\"description\":\"Guest author Timothy Mathis has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to bring a specific value when doing VLOOKUP?","description":"VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a","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:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/","og_locale":"en_US","og_type":"article","og_title":"How to bring a specific value when doing VLOOKUP?","og_description":"VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a","og_url":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-06-14T13:26:49+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Timothy Mathis","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Timothy Mathis","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/"},"author":{"name":"Timothy Mathis","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318"},"headline":"How to bring a specific value when doing VLOOKUP?","datePublished":"2024-06-14T13:26:49+00:00","dateModified":"2024-06-14T13:26:49+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/"},"wordCount":820,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/","url":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/","name":"How to bring a specific value when doing VLOOKUP?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-06-14T13:26:49+00:00","dateModified":"2024-06-14T13:26:49+00:00","description":"VLOOKUP is a powerful function in Excel that allows you to search for a specific value in a data table and fetch corresponding information from a","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-bring-a-specific-value-when-doing-vlookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to bring a specific value when doing VLOOKUP?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318","name":"Timothy Mathis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Timothy Mathis"},"description":"Guest author Timothy Mathis has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/256083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=256083"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/256083\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=256083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=256083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=256083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}