{"id":228811,"date":"2024-05-24T19:10:03","date_gmt":"2024-05-24T19:10:03","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=228811"},"modified":"2024-05-24T19:10:03","modified_gmt":"2024-05-24T19:10:03","slug":"how-to-lookup-text-in-excel-and-return-a-value","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/","title":{"rendered":"How to lookup text in Excel and return a value?"},"content":{"rendered":"<p>**How to lookup text in Excel and return a value?**<\/p>\n<p>Excel is a powerful tool that allows you to perform various calculations and data manipulations. One common task is looking up text in a cell and returning a corresponding value. Whether you need to find a customer&#8217;s name and display their corresponding ID number or locate a specific keyword within a range of cells and retrieve related information, Excel provides several functions that can help you achieve this. In this article, we will explore some of the methods you can use to lookup text in Excel and return a value.<\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#1_How_do_I_use_the_VLOOKUP_function\" title=\"1. How do I use the VLOOKUP function?\">1. How do I use the VLOOKUP function?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#2_What_is_the_syntax_of_the_VLOOKUP_function\" title=\"2. What is the syntax of the VLOOKUP function?\">2. What is the syntax of the VLOOKUP function?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#3_What_is_the_difference_between_TRUE_and_FALSE_in_the_range_lookup_argument\" title=\"3. What is the difference between TRUE and FALSE in the range_lookup argument?\">3. What is the difference between TRUE and FALSE in the range_lookup argument?<\/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-lookup-text-in-excel-and-return-a-value\/#4_Can_I_use_wildcards_with_the_VLOOKUP_function\" title=\"4. Can I use wildcards with the VLOOKUP function?\">4. Can I use wildcards with the VLOOKUP function?<\/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-lookup-text-in-excel-and-return-a-value\/#5_What_is_the_INDEX_and_MATCH_combination\" title=\"5. What is the INDEX and MATCH combination?\">5. What is the INDEX and MATCH combination?<\/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-lookup-text-in-excel-and-return-a-value\/#6_Can_I_lookup_text_in_multiple_columns_using_INDEX_and_MATCH\" title=\"6. Can I lookup text in multiple columns using INDEX and MATCH?\">6. Can I lookup text in multiple columns using INDEX and MATCH?<\/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-lookup-text-in-excel-and-return-a-value\/#7_How_can_I_search_for_multiple_criteria_in_Excel\" title=\"7. How can I search for multiple criteria in Excel?\">7. How can I search for multiple criteria in Excel?<\/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-lookup-text-in-excel-and-return-a-value\/#8_What_is_the_HLOOKUP_function\" title=\"8. What is the HLOOKUP function?\">8. What is the HLOOKUP function?<\/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-lookup-text-in-excel-and-return-a-value\/#9_Can_I_perform_a_case-insensitive_lookup\" title=\"9. Can I perform a case-insensitive lookup?\">9. Can I perform a case-insensitive lookup?<\/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-lookup-text-in-excel-and-return-a-value\/#10_What_if_my_value_is_not_found\" title=\"10. What if my value is not found?\">10. What if my value is not found?<\/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-lookup-text-in-excel-and-return-a-value\/#11_Are_there_any_other_lookup_functions_in_Excel\" title=\"11. Are there any other lookup functions in Excel?\">11. Are there any other lookup functions in Excel?<\/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-lookup-text-in-excel-and-return-a-value\/#12_Can_I_use_a_combination_of_different_lookup_functions\" title=\"12. Can I use a combination of different lookup functions?\">12. Can I use a combination of different lookup functions?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_How_do_I_use_the_VLOOKUP_function\"><\/span>1. How do I use the VLOOKUP function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe VLOOKUP function is one of the most popular ways to lookup text in Excel. It allows you to search for a value in the leftmost column of a range and retrieve a corresponding value from a specified column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_What_is_the_syntax_of_the_VLOOKUP_function\"><\/span>2. What is the syntax of the VLOOKUP function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_What_is_the_difference_between_TRUE_and_FALSE_in_the_range_lookup_argument\"><\/span>3. What is the difference between TRUE and FALSE in the range_lookup argument?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you enter TRUE or omit the range_lookup argument, Excel will perform an approximate match. On the other hand, entering FALSE will force an exact match.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Can_I_use_wildcards_with_the_VLOOKUP_function\"><\/span>4. Can I use wildcards with the VLOOKUP function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the VLOOKUP function does not support wildcards. If you need to use wildcards, you can combine the VLOOKUP function with other functions like CONCATENATE or LEFT.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_What_is_the_INDEX_and_MATCH_combination\"><\/span>5. What is the INDEX and MATCH combination?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe INDEX and MATCH combination is an alternative to VLOOKUP. It allows you to find the position of a value in a range and retrieve a corresponding value from another column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_I_lookup_text_in_multiple_columns_using_INDEX_and_MATCH\"><\/span>6. Can I lookup text in multiple columns using INDEX and MATCH?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, unlike VLOOKUP, the INDEX and MATCH combination allows you to retrieve data from any column in the range, not just to the right of the lookup column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_How_can_I_search_for_multiple_criteria_in_Excel\"><\/span>7. How can I search for multiple criteria in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo search for multiple criteria in Excel, you can use a combination of functions like INDEX, MATCH, and IF. By nesting these functions, you can build complex lookup formulas.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_What_is_the_HLOOKUP_function\"><\/span>8. What is the HLOOKUP function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe HLOOKUP function is similar to VLOOKUP, but it searches for a value in the top row of a range and retrieves a corresponding value from a specified row.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_perform_a_case-insensitive_lookup\"><\/span>9. Can I perform a case-insensitive lookup?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nBy default, the VLOOKUP and HLOOKUP functions are case-insensitive. However, you can use the EXACT function in combination with these functions to perform a case-sensitive lookup.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_What_if_my_value_is_not_found\"><\/span>10. What if my value is not found?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf the VLOOKUP or HLOOKUP function cannot find the lookup value, it will return an error. To handle this, you can use the IFERROR function to display a custom message or value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Are_there_any_other_lookup_functions_in_Excel\"><\/span>11. Are there any other lookup functions in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, apart from VLOOKUP, HLOOKUP, INDEX, and MATCH, Excel offers other lookup functions like XLOOKUP, LOOKUP, CHOOSE, OFFSET, and more. These functions cater to different lookup requirements.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_use_a_combination_of_different_lookup_functions\"><\/span>12. Can I use a combination of different lookup functions?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nDefinitely! Depending on your specific needs, you can mix and match different lookup functions, or even nest them within each other, to achieve complex lookup tasks in Excel.<\/p>\n<p>Excel provides a wide array of functions to lookup text in cells and return corresponding values. Whether you prefer using VLOOKUP, INDEX and MATCH, or any other lookup function, understanding these features will empower you to extract relevant information efficiently. So, the next time you need to lookup text in Excel, remember the numerous options at your disposal, and select the most suitable method based on your specific requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>**How to lookup text in Excel and return a value?** Excel is a powerful tool that allows you to perform various calculations and data manipulations. One common task is looking up text in a cell and returning a corresponding value. Whether you need to find a customer&#8217;s name and display their corresponding ID number or &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to lookup text in Excel and return a value?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#more-228811\">Read more<span class=\"screen-reader-text\">How to lookup text in Excel and return a value?<\/span><\/a><\/p>\n","protected":false},"author":57,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-228811","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 lookup text in Excel and return a value?<\/title>\n<meta name=\"description\" content=\"**How to lookup text in Excel and return a value?** Excel is a powerful tool that allows you to perform various calculations and data manipulations. One\" \/>\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-lookup-text-in-excel-and-return-a-value\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to lookup text in Excel and return a value?\" \/>\n<meta property=\"og:description\" content=\"**How to lookup text in Excel and return a value?** Excel is a powerful tool that allows you to perform various calculations and data manipulations. One\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/\" \/>\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-05-24T19:10:03+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=\"Casey Mayer\" \/>\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=\"Casey Mayer\" \/>\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:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/\"},\"author\":{\"name\":\"Casey Mayer\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f\"},\"headline\":\"How to lookup text in Excel and return a value?\",\"datePublished\":\"2024-05-24T19:10:03+00:00\",\"dateModified\":\"2024-05-24T19:10:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/\"},\"wordCount\":619,\"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-lookup-text-in-excel-and-return-a-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/\",\"name\":\"How to lookup text in Excel and return a value?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-05-24T19:10:03+00:00\",\"dateModified\":\"2024-05-24T19:10:03+00:00\",\"description\":\"**How to lookup text in Excel and return a value?** Excel is a powerful tool that allows you to perform various calculations and data manipulations. One\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to lookup text in Excel and return a value?\"}]},{\"@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\/89e431077ef417dfaa131f435124f18f\",\"name\":\"Casey Mayer\",\"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\":\"Casey Mayer\"},\"description\":\"Guest author Casey Mayer 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 lookup text in Excel and return a value?","description":"**How to lookup text in Excel and return a value?** Excel is a powerful tool that allows you to perform various calculations and data manipulations. One","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-lookup-text-in-excel-and-return-a-value\/","og_locale":"en_US","og_type":"article","og_title":"How to lookup text in Excel and return a value?","og_description":"**How to lookup text in Excel and return a value?** Excel is a powerful tool that allows you to perform various calculations and data manipulations. One","og_url":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-05-24T19:10:03+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":"Casey Mayer","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Casey Mayer","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/"},"author":{"name":"Casey Mayer","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f"},"headline":"How to lookup text in Excel and return a value?","datePublished":"2024-05-24T19:10:03+00:00","dateModified":"2024-05-24T19:10:03+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/"},"wordCount":619,"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-lookup-text-in-excel-and-return-a-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/","url":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/","name":"How to lookup text in Excel and return a value?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-05-24T19:10:03+00:00","dateModified":"2024-05-24T19:10:03+00:00","description":"**How to lookup text in Excel and return a value?** Excel is a powerful tool that allows you to perform various calculations and data manipulations. One","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-text-in-excel-and-return-a-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to lookup text in Excel and return a value?"}]},{"@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\/89e431077ef417dfaa131f435124f18f","name":"Casey Mayer","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":"Casey Mayer"},"description":"Guest author Casey Mayer 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\/228811","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\/57"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=228811"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/228811\/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=228811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=228811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=228811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}