{"id":113392,"date":"2025-11-21T15:49:07","date_gmt":"2025-11-21T10:19:07","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/"},"modified":"2025-11-21T13:17:06","modified_gmt":"2025-11-21T07:47:06","slug":"lookup-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/","title":{"rendered":"How to Use the LOOKUP Function in Excel?"},"content":{"rendered":"\n<p>The LOOKUP function is one of Excel\u2019s most helpful resources when you need to pull information from a list without scrolling through it manually. Whether you need to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Match IDs<\/li>\n\n\n\n<li>Find Prices<\/li>\n\n\n\n<li>Link Related Data<\/li>\n<\/ul>\n\n\n\n<p>LOOKUP makes the process quick. In this tutorial, you\u2019ll learn how to use the LOOKUP function step by step by understanding its syntax and using it in practical examples.<\/p>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Academy Pro<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\" class=\"courses-cta-title-link\">Microsoft Excel Course<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn Excel the smart way! Our course teaches you all the essential tools and techniques to master spreadsheets, from formulas to charts, and improve your workflow in every task you do.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>10 Hrs<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>2 Projects<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\" class=\"courses-cta-button\">\n                Learn Excel\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-the-lookup-function-in-excel\"><strong>What is the LOOKUP Function in Excel?<\/strong><\/h2>\n\n\n\n<p>The <strong>LOOKUP function in Excel<\/strong> searches for a value in one range and returns a corresponding value from another range.&nbsp;<\/p>\n\n\n\n<p>It helps you quickly find related information, such as matching a product ID to its price based on a lookup value.<\/p>\n\n\n\n<p><strong>Major Rule:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LOOKUP <strong>requires<\/strong> your data to be sorted in ascending order (A-Z or Smallest to Largest).&nbsp;<\/li>\n\n\n\n<li>If your data is not sorted, the function may return incorrect results without showing an error.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-use-the-lookup-function-in-excel\"><strong>How to Use the LOOKUP Function in Excel?<\/strong><\/h2>\n\n\n\n<p>Excel might show you two options when you type the formula: <em>Vector<\/em> and <em>Array<\/em>.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Vector Form (Recommended):<\/strong> Use this to search one row or column and find a result in a different row or column.\n<ul class=\"wp-block-list\">\n<li><strong>Formula:<\/strong> =LOOKUP(lookup_value, lookup_vector, result_vector)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Array Form:<\/strong> This is an older method provided for compatibility with other spreadsheet programs. It is rarely used today. It only works if the lookup data (array) has the lookup value in the first row or first column.<\/li>\n<\/ol>\n\n\n\n<p>We will focus on the Vector form because it is much more flexible and easier to use.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-198.png\"><img decoding=\"async\" width=\"705\" height=\"833\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-198.png\" alt=\"\" class=\"wp-image-113400\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-198.png 705w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-198-254x300.png 254w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-198-150x177.png 150w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/figure>\n\n\n\n<p>Explanation of Each Argument:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>lookup_value <em>(required)<\/em>\n<ul class=\"wp-block-list\">\n<li>This is the value you want to search for.<\/li>\n\n\n\n<li>It can be a number, text, or cell reference.<\/li>\n\n\n\n<li>Excel matches this value or returns the next smallest value in the sorted lookup_vector.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>lookup_vector <em>(required)<\/em>\n<ul class=\"wp-block-list\">\n<li>This is the one-dimensional range (either a row or column) where Excel will look for the lookup_value.<\/li>\n\n\n\n<li>Example: a list of marks, product prices, or age groups.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>result_vector <em>(optional but typically used)<\/em>\n<ul class=\"wp-block-list\">\n<li>This is the range from which Excel will return a result corresponding to the matched value in lookup_vector.<\/li>\n\n\n\n<li>It must be the same size and same orientation (row or column) as the lookup_vector.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>If you omit the result_vector, Excel assumes that your lookup_vector is also your result source.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>How it behaves:<\/strong> Excel will search for the lookup_value in the lookup_vector and, once found, return that <strong>same value<\/strong> to you. This is useful if you simply want to confirm that a value exists in a list.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-by-step-example\"><strong>Step-by-Step Example<\/strong><\/h2>\n\n\n\n<p>Suppose you are a teacher with a list of student marks and corresponding grades. You want to enter a student's score and have it automatically return their grade.<\/p>\n\n\n\n<p><strong>Data Table<\/strong><\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-192.png\"><img decoding=\"async\" width=\"556\" height=\"306\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-192.png\" alt=\"\" class=\"wp-image-113394\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-192.png 556w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-192-300x165.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-192-150x83.png 150w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/figure>\n\n\n\n<p><strong>Task:<\/strong><\/p>\n\n\n\n<p>Look up a <strong>student\u2019s score of 65<\/strong> and find the appropriate <strong>grade<\/strong>.<\/p>\n\n\n\n<p><strong>Formula:<\/strong><\/p>\n\n\n\n<p>=LOOKUP(65, A2:A5, B2:B5)<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-194.png\"><img decoding=\"async\" width=\"653\" height=\"324\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-194.png\" alt=\"\" class=\"wp-image-113396\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-194.png 653w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-194-300x149.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-194-150x74.png 150w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/figure>\n\n\n\n<p><strong>Step-by-Step Explanation:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Excel checks the lookup_vector<\/strong> \u2192 which is A2:A5 (marks).<\/li>\n\n\n\n<li>It tries to find an exact match for <strong>65<\/strong>.<\/li>\n\n\n\n<li>Since 65 is not on the list, Excel looks for the <strong>largest value<\/strong> that is less than or equal to 65.\n<ul class=\"wp-block-list\">\n<li>In this case, it\u2019s <strong>60<\/strong>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Excel then identifies the <strong>position 60<\/strong> in the lookup_vector, <strong>row 4<\/strong> (A4).<\/li>\n\n\n\n<li>It returns the <strong>corresponding value<\/strong> from the same row in result_vector \u2192 B4, which is <strong>\"B\"<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p><strong>Final Output:<\/strong><\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-195.png\"><img decoding=\"async\" width=\"559\" height=\"267\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-195.png\" alt=\"\" class=\"wp-image-113397\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-195.png 559w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-195-300x143.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-195-150x72.png 150w\" sizes=\"(max-width: 559px) 100vw, 559px\" \/><\/figure>\n\n\n\n<p>This tells us that a score of 65 earns a grade of <strong>\"B\"<\/strong>.<\/p>\n\n\n\n<p><strong>Important Notes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the lookup_value is <strong>less than the smallest value<\/strong> in the lookup_vector, the function returns <strong>#N\/A<\/strong>.<\/li>\n\n\n\n<li>This function performs an <strong>approximate match<\/strong>, not an exact one, unless the value is exactly present.<\/li>\n<\/ul>\n\n\n\n<p class=\"block-course-highlighter\">New to Excel? Start with this free Excel for Beginners course to strengthen your Excel fundamentals.<\/p>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Free Course<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/excel-for-beginners\" class=\"courses-cta-title-link\">Excel for Beginners Free Course<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn essential Excel skills for data analysis, including functions, formulas, and data visualization techniques. Master cell referencing, sorting, and creating charts and presentations.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>Beginner Level<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>7.5 hrs<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/excel-for-beginners\" class=\"courses-cta-button\">\n                Enroll Free\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-happens-if-the-value-isnt-found\">What Happens If the Value Isn\u2019t Found?<\/h2>\n\n\n\n<p>There are two main cases where the LOOKUP function fails or gives incorrect results:<\/p>\n\n\n\n<p><strong>1. If <\/strong><strong>lookup_value<\/strong><strong> &lt; all values in the lookup range:<\/strong><\/p>\n\n\n\n<p>Excel returns <strong>#N\/A<\/strong> because there\u2019s no value less than or equal to the lookup_value.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-196.png\"><img decoding=\"async\" width=\"549\" height=\"376\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-196.png\" alt=\"\" class=\"wp-image-113398\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-196.png 549w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-196-300x205.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-196-150x103.png 150w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/figure>\n\n\n\n<p><strong>Formula<\/strong><\/p>\n\n\n\n<p>=LOOKUP(16, A2:A4)<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-197.png\"><img decoding=\"async\" width=\"561\" height=\"222\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-197.png\" alt=\"\" class=\"wp-image-113399\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-197.png 561w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-197-300x119.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-197-150x59.png 150w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Since <strong>16 is smaller than the lowest value (18)<\/strong>, the result will be: #N\/A<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image aligncenter size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-193.png\"><img decoding=\"async\" width=\"465\" height=\"186\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-193.png\" alt=\"\" class=\"wp-image-113395\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-193.png 465w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-193-300x120.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/image-193-150x60.png 150w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/figure>\n\n\n\n<p><strong>2. If the lookup vector is not sorted:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The function will not show an error, but may return the <em>wrong<\/em> result.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary-table-how-lookup-handles-value-matching\"><strong>Summary Table: How LOOKUP Handles Value Matching<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Scenario<\/strong><\/td><td><strong>Result<\/strong><\/td><td><strong>Notes<\/strong><\/td><\/tr><tr><td>Exact match found<\/td><td>Returns match<\/td><td>Standard behavior<\/td><\/tr><tr><td>No exact match, a smaller value exists<\/td><td>Returns the nearest smaller match<\/td><td>Only if the data is sorted in ascending order<\/td><\/tr><tr><td>No smaller value exists<\/td><td>#N\/A<\/td><td>Lookup value is less than all entries<\/td><\/tr><tr><td>Data not sorted<\/td><td>Unreliable result<\/td><td>May return the wrong value or unexpected output<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Academy Pro<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\" class=\"courses-cta-title-link\">Microsoft Excel Course<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn Excel the smart way! Our course teaches you all the essential tools and techniques to master spreadsheets, from formulas to charts, and improve your workflow in every task you do.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>10 Hrs<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>2 Projects<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\" class=\"courses-cta-button\">\n                Learn Excel\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"tips-and-best-practices-for-using-the-lookup-function-in-excel\">Tips and Best Practices for Using the LOOKUP Function in Excel<\/h2>\n\n\n\n<p><strong>1. Use LOOKUP Only When Approximate Matching Is Acceptable<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LOOKUP is designed for <strong>approximate matches<\/strong> by default.<\/li>\n\n\n\n<li>Use VLOOKUP, HLOOKUP, or XLOOKUP if you need exact matches.<\/li>\n<\/ul>\n\n\n\n<p><strong>2. Use Descriptive Named Ranges for Better Readability<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Define named ranges and result vectors for your lookup.<\/li>\n\n\n\n<li>This makes formulas easier to understand and manage.<\/li>\n<\/ul>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<p>=LOOKUP(ProductID, ProductIDs, Prices)<\/p>\n\n\n\n<p><strong>3. Avoid Using LOOKUP with Volatile or Frequently Changing Data<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LOOKUP relies on sorted data and approximate matching; it may not adapt well to datasets that change often or include dynamic user inputs.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p><strong>4. Document Your Formula Logic<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add comments or cell notes explaining what your LOOKUP formula does.<\/li>\n\n\n\n<li>This is especially helpful in shared or complex spreadsheets.<\/li>\n<\/ul>\n\n\n\n<p>Learning the LOOKUP function in Excel can be a useful tool for effective data analysis, as it helps you quickly find data as per your query.<\/p>\n\n\n\n<p>For those who want to strengthen their skills in using various Excel formulas for assigned tasks, Great Learning\u2019s <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\">Data Analytics in Excel course<\/a> provides hands-on training to help you become better at handling data and extracting meaningful insights from complex datasets that support data-driven decision-making for organizational growth.<\/p>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Academy Pro<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\" class=\"courses-cta-title-link\">Excel for Data Analysis<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn Excel for powerful data analysis and enhance your skills for better decision-making.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>5.5 Hrs<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>2 Projects<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\" class=\"courses-cta-button\">\n                Learn Excel for Data Analysis\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.<\/p>\n","protected":false},"author":41,"featured_media":113405,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[9],"tags":[36822],"content_type":[],"class_list":["post-113392","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","tag-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Use the LOOKUP Function in Excel?<\/title>\n<meta name=\"description\" content=\"Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use the LOOKUP Function in Excel?\" \/>\n<meta property=\"og:description\" content=\"Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Great Learning Blog: Free Resources what Matters to shape your Career!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GreatLearningOfficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-21T10:19:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1408\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Great Learning Editorial Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/Great_Learning\" \/>\n<meta name=\"twitter:site\" content=\"@Great_Learning\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Great Learning Editorial Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/\"},\"author\":{\"name\":\"Great Learning Editorial Team\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\"},\"headline\":\"How to Use the LOOKUP Function in Excel?\",\"datePublished\":\"2025-11-21T10:19:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/\"},\"wordCount\":987,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/lookup-function-excel.webp\",\"keywords\":[\"excel\"],\"articleSection\":[\"Data Science and Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/\",\"name\":\"How to Use the LOOKUP Function in Excel?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/lookup-function-excel.webp\",\"datePublished\":\"2025-11-21T10:19:07+00:00\",\"description\":\"Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/lookup-function-excel.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/lookup-function-excel.webp\",\"width\":1408,\"height\":768,\"caption\":\"How to Use the LOOKUP Function in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/lookup-function-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Science and Analytics\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/data-science\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Use the LOOKUP Function in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"name\":\"Great Learning Blog\",\"description\":\"Learn, Upskill &amp; Career Development Guide and Resources\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"alternateName\":\"Great Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\",\"name\":\"Great Learning\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"width\":900,\"height\":900,\"caption\":\"Great Learning\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/GreatLearningOfficial\\\/\",\"https:\\\/\\\/x.com\\\/Great_Learning\",\"https:\\\/\\\/www.instagram.com\\\/greatlearningofficial\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/in.pinterest.com\\\/greatlearning12\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/beaconelearning\\\/\"],\"description\":\"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.\",\"email\":\"info@mygreatlearning.com\",\"legalName\":\"Great Learning Education Services Pvt. Ltd\",\"foundingDate\":\"2013-11-29\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\",\"name\":\"Great Learning Editorial Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"caption\":\"Great Learning Editorial Team\"},\"description\":\"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.\",\"sameAs\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/\",\"https:\\\/\\\/in.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/Great_Learning\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCObs0kLIrDjX2LLSybqNaEA\"],\"award\":[\"Best EdTech Company of the Year 2024\",\"Education Economictimes Outstanding Education\\\/Edtech Solution Provider of the Year 2024\",\"Leading E-learning Platform 2024\"],\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/author\\\/greatlearning\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Use the LOOKUP Function in Excel?","description":"Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.","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:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Use the LOOKUP Function in Excel?","og_description":"Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.","og_url":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/","og_site_name":"Great Learning Blog: Free Resources what Matters to shape your Career!","article_publisher":"https:\/\/www.facebook.com\/GreatLearningOfficial\/","article_published_time":"2025-11-21T10:19:07+00:00","og_image":[{"width":1408,"height":768,"url":"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp","type":"image\/webp"}],"author":"Great Learning Editorial Team","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/Great_Learning","twitter_site":"@Great_Learning","twitter_misc":{"Written by":"Great Learning Editorial Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/"},"author":{"name":"Great Learning Editorial Team","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad"},"headline":"How to Use the LOOKUP Function in Excel?","datePublished":"2025-11-21T10:19:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/"},"wordCount":987,"publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp","keywords":["excel"],"articleSection":["Data Science and Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/","url":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/","name":"How to Use the LOOKUP Function in Excel?","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp","datePublished":"2025-11-21T10:19:07+00:00","description":"Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.","breadcrumb":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/#primaryimage","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp","width":1408,"height":768,"caption":"How to Use the LOOKUP Function in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mygreatlearning.com\/blog\/lookup-function-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.mygreatlearning.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Science and Analytics","item":"https:\/\/www.mygreatlearning.com\/blog\/data-science\/"},{"@type":"ListItem","position":3,"name":"How to Use the LOOKUP Function in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.mygreatlearning.com\/blog\/#website","url":"https:\/\/www.mygreatlearning.com\/blog\/","name":"Great Learning Blog","description":"Learn, Upskill &amp; Career Development Guide and Resources","publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"alternateName":"Great Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mygreatlearning.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization","name":"Great Learning","url":"https:\/\/www.mygreatlearning.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","width":900,"height":900,"caption":"Great Learning"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/GreatLearningOfficial\/","https:\/\/x.com\/Great_Learning","https:\/\/www.instagram.com\/greatlearningofficial\/","https:\/\/www.linkedin.com\/school\/great-learning\/","https:\/\/in.pinterest.com\/greatlearning12\/","https:\/\/www.youtube.com\/user\/beaconelearning\/"],"description":"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.","email":"info@mygreatlearning.com","legalName":"Great Learning Education Services Pvt. Ltd","foundingDate":"2013-11-29","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad","name":"Great Learning Editorial Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","caption":"Great Learning Editorial Team"},"description":"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.","sameAs":["https:\/\/www.mygreatlearning.com\/","https:\/\/in.linkedin.com\/school\/great-learning\/","https:\/\/x.com\/https:\/\/twitter.com\/Great_Learning","https:\/\/www.youtube.com\/channel\/UCObs0kLIrDjX2LLSybqNaEA"],"award":["Best EdTech Company of the Year 2024","Education Economictimes Outstanding Education\/Edtech Solution Provider of the Year 2024","Leading E-learning Platform 2024"],"url":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp",1408,768,false],"thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel-150x150.webp",150,150,true],"medium":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel-300x164.webp",300,164,true],"medium_large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel-768x419.webp",768,419,true],"large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel-1024x559.webp",1024,559,true],"1536x1536":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp",1408,768,false],"2048x2048":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel.webp",1408,768,false],"web-stories-poster-portrait":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel-640x768.webp",640,768,true],"web-stories-publisher-logo":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel-96x96.webp",96,96,true],"web-stories-thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/11\/lookup-function-excel-150x82.webp",150,82,true]},"uagb_author_info":{"display_name":"Great Learning Editorial Team","author_link":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"},"uagb_comment_info":0,"uagb_excerpt":"Learn how to use the LOOKUP function by understanding its syntax and applying it in practical examples.","_links":{"self":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/113392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/comments?post=113392"}],"version-history":[{"count":7,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/113392\/revisions"}],"predecessor-version":[{"id":113402,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/113392\/revisions\/113402"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media\/113405"}],"wp:attachment":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media?parent=113392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/categories?post=113392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/tags?post=113392"},{"taxonomy":"content_type","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/content_type?post=113392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}