{"id":228807,"date":"2024-03-31T04:32:15","date_gmt":"2024-03-31T04:32:15","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=228807"},"modified":"2024-03-31T04:32:15","modified_gmt":"2024-03-31T04:32:15","slug":"how-to-lookup-in-excel-and-return-a-value","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/","title":{"rendered":"How to lookup in Excel and return a value?"},"content":{"rendered":"<p>Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel is the lookup function, which allows you to search for a specific value in a range of cells and return a corresponding value from another column or row. Learning how to use lookup functions effectively can save you valuable time and effort when working with large data sets or complex spreadsheets. In this article, we will explore different methods to lookup 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#VLOOKUP_Function\" title=\"VLOOKUP Function\">VLOOKUP Function<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#How_to_use_VLOOKUP_in_Excel\" title=\"How to use VLOOKUP in Excel?\">How to use VLOOKUP in Excel?<\/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-in-excel-and-return-a-value\/#What_is_lookup_value_in_VLOOKUP\" title=\"What is lookup_value in VLOOKUP?\">What is lookup_value in VLOOKUP?<\/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-in-excel-and-return-a-value\/#What_is_table_array_in_VLOOKUP\" title=\"What is table_array in VLOOKUP?\">What is table_array in VLOOKUP?<\/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-in-excel-and-return-a-value\/#What_is_col_index_num_in_VLOOKUP\" title=\"What is col_index_num in VLOOKUP?\">What is col_index_num in VLOOKUP?<\/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-in-excel-and-return-a-value\/#What_is_range_lookup_in_VLOOKUP\" title=\"What is range_lookup in VLOOKUP?\">What is range_lookup in VLOOKUP?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#INDEX_and_MATCH_Combination\" title=\"INDEX and MATCH Combination\">INDEX and MATCH Combination<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#How_to_use_INDEX_and_MATCH_combination_for_lookup_in_Excel\" title=\"How to use INDEX and MATCH combination for lookup in Excel?\">How to use INDEX and MATCH combination for lookup in Excel?<\/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-in-excel-and-return-a-value\/#Can_I_use_INDEX_and_MATCH_combination_instead_of_VLOOKUP\" title=\"Can I use INDEX and MATCH combination instead of VLOOKUP?\">Can I use INDEX and MATCH combination instead of VLOOKUP?<\/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-in-excel-and-return-a-value\/#Can_I_use_INDEX_and_MATCH_for_vertical_and_horizontal_lookups\" title=\"Can I use INDEX and MATCH for vertical and horizontal lookups?\">Can I use INDEX and MATCH for vertical and horizontal lookups?<\/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-in-excel-and-return-a-value\/#How_to_handle_errors_in_INDEX_and_MATCH\" title=\"How to handle errors in INDEX and MATCH?\">How to handle errors in INDEX and MATCH?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#HLOOKUP_Function\" title=\"HLOOKUP Function\">HLOOKUP Function<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#Can_I_use_HLOOKUP_for_vertical_lookups\" title=\"Can I use HLOOKUP for vertical lookups?\">Can I use HLOOKUP for vertical lookups?<\/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-lookup-in-excel-and-return-a-value\/#What_is_row_index_num_in_HLOOKUP\" title=\"What is row_index_num in HLOOKUP?\">What is row_index_num in HLOOKUP?<\/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-lookup-in-excel-and-return-a-value\/#Is_HLOOKUP_case-sensitive\" title=\"Is HLOOKUP case-sensitive?\">Is HLOOKUP case-sensitive?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#What_is_required_for_successful_lookup_in_Excel\" title=\"What is required for successful lookup in Excel?\">What is required for successful lookup in Excel?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"VLOOKUP_Function\"><\/span>VLOOKUP Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The VLOOKUP function is one of the most commonly used lookup functions in Excel. It allows you to search for a value in the leftmost column of a table and return a corresponding value from a specified column. Here&#8217;s how you can use VLOOKUP:<\/p>\n<blockquote><p>\n=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)\n<\/p><\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"How_to_use_VLOOKUP_in_Excel\"><\/span>How to use VLOOKUP in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo use VLOOKUP, you need to provide the lookup value, the table range where you want to search for the value, the column index number where the result will be found, and specify whether you want an exact match or an approximate match.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_lookup_value_in_VLOOKUP\"><\/span>What is lookup_value in VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe lookup_value is the value you want to search for in the table range.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_table_array_in_VLOOKUP\"><\/span>What is table_array in VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe table_array is the range of cells where the lookup value and the result are located.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_col_index_num_in_VLOOKUP\"><\/span>What is col_index_num in VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe col_index_num is the column number in the table_array from which you want to return the result.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_range_lookup_in_VLOOKUP\"><\/span>What is range_lookup in VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe range_lookup parameter is optional. If you enter &#8220;TRUE&#8221; or don&#8217;t enter anything, the function will find the closest match. If you enter &#8220;FALSE&#8221;, the function will look for an exact match.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"INDEX_and_MATCH_Combination\"><\/span>INDEX and MATCH Combination<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>While VLOOKUP is widely used, another powerful method to lookup and return a value in Excel is by using the combination of the INDEX and MATCH functions. INDEX returns the value in a given range based on a specified row and column number, while MATCH returns the position of a value in a given range. Here&#8217;s how you can use INDEX and MATCH together:<\/p>\n<blockquote><p>\n=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))\n<\/p><\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"How_to_use_INDEX_and_MATCH_combination_for_lookup_in_Excel\"><\/span>How to use INDEX and MATCH combination for lookup in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo use INDEX and MATCH together, provide the return range (range where you want to retrieve the result), the lookup value, the lookup range (range where you want to search for the value), and 0 to specify an exact match.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_use_INDEX_and_MATCH_combination_instead_of_VLOOKUP\"><\/span>Can I use INDEX and MATCH combination instead of VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, the INDEX and MATCH combination provides more flexibility and control over the search criteria compared to VLOOKUP. It is particularly useful when the lookup column is not in the first column of the table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_use_INDEX_and_MATCH_for_vertical_and_horizontal_lookups\"><\/span>Can I use INDEX and MATCH for vertical and horizontal lookups?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use INDEX and MATCH for both vertical and horizontal lookups by switching the return range and lookup range accordingly.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_handle_errors_in_INDEX_and_MATCH\"><\/span>How to handle errors in INDEX and MATCH?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo handle errors in INDEX and MATCH, you can use error handling functions like IFERROR or ISERROR to display a specific value or message when no match is found.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"HLOOKUP_Function\"><\/span>HLOOKUP Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Apart from VLOOKUP and INDEX\/MATCH, Excel also provides the HLOOKUP function, which performs a horizontal lookup. HLOOKUP works similar to VLOOKUP but searches for the lookup value in the topmost row of the table and returns a value from the corresponding row. Here&#8217;s how you can use HLOOKUP:<\/p>\n<blockquote><p>\n=HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)\n<\/p><\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_use_HLOOKUP_for_vertical_lookups\"><\/span>Can I use HLOOKUP for vertical lookups?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nSorry, HLOOKUP is specifically designed for horizontal lookups. For vertical lookups, you should use VLOOKUP or INDEX\/MATCH.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_row_index_num_in_HLOOKUP\"><\/span>What is row_index_num in HLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe row_index_num specifies the row number from which you want to return the result.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_HLOOKUP_case-sensitive\"><\/span>Is HLOOKUP case-sensitive?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, HLOOKUP is case-sensitive. Make sure the lookup value in the topmost row exactly matches the case of the search value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_required_for_successful_lookup_in_Excel\"><\/span>What is required for successful lookup in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nFor a successful lookup in Excel, ensure that the lookup value exists in the search range, the search range is sorted in ascending order (for approximate matches in VLOOKUP), and there are no duplicate values.<\/p>\n<p>In conclusion, learning how to lookup in Excel and return a value is essential for efficiently working with large datasets and complex spreadsheets. Whether you choose VLOOKUP, INDEX\/MATCH, or HLOOKUP, these functions will greatly enhance your data analysis and decision-making abilities.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel is the lookup function, which allows you to search for a specific value in a range of cells and return a corresponding value from another column or row. &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to lookup in Excel and return a value?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#more-228807\">Read more<span class=\"screen-reader-text\">How to lookup 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-228807","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 in Excel and return a value?<\/title>\n<meta name=\"description\" content=\"Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel\" \/>\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-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 in Excel and return a value?\" \/>\n<meta property=\"og:description\" content=\"Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-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-03-31T04:32:15+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=\"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-lookup-in-excel-and-return-a-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/\"},\"author\":{\"name\":\"Casey Mayer\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f\"},\"headline\":\"How to lookup in Excel and return a value?\",\"datePublished\":\"2024-03-31T04:32:15+00:00\",\"dateModified\":\"2024-03-31T04:32:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/\"},\"wordCount\":777,\"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-in-excel-and-return-a-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/\",\"name\":\"How to lookup in Excel and return a value?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-03-31T04:32:15+00:00\",\"dateModified\":\"2024-03-31T04:32:15+00:00\",\"description\":\"Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-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 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 in Excel and return a value?","description":"Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel","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-in-excel-and-return-a-value\/","og_locale":"en_US","og_type":"article","og_title":"How to lookup in Excel and return a value?","og_description":"Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel","og_url":"https:\/\/namso-gen.co\/blog\/how-to-lookup-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-03-31T04:32:15+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/"},"author":{"name":"Casey Mayer","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f"},"headline":"How to lookup in Excel and return a value?","datePublished":"2024-03-31T04:32:15+00:00","dateModified":"2024-03-31T04:32:15+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/"},"wordCount":777,"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-in-excel-and-return-a-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/","url":"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/","name":"How to lookup in Excel and return a value?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-03-31T04:32:15+00:00","dateModified":"2024-03-31T04:32:15+00:00","description":"Excel is a powerful tool that offers a wide range of functions to perform various calculations and tasks. One of the most commonly used features of Excel","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-lookup-in-excel-and-return-a-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-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 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\/228807","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=228807"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/228807\/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=228807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=228807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=228807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}