{"id":16108,"date":"2023-07-27T09:30:18","date_gmt":"2023-07-27T09:30:18","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=16108"},"modified":"2024-02-19T14:52:07","modified_gmt":"2024-02-19T14:52:07","slug":"difference-between-lookup-and-vlookup-functions","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/","title":{"rendered":"Difference Between LOOKUP and VLOOKUP Functions"},"content":{"rendered":"\n
Difference-Between-LOOKUP-and-VLOOKUP-Functions<\/a>Download File<\/a><\/div>\n\n\n\n

VLOOKUP<\/strong> is one of the most widely used formulas in Excel. A similar formula, from the same family for that matter, is LOOKUP<\/strong>, which is also commonly used to search for certain data in a table and to retrieve certain information.<\/p>\n\n\n\n

These two formulas, although similar in their core functionality, are slightly different<\/strong>. In the example below, we will show how exactly<\/strong>.<\/p>\n\n\n\n

Using VLOOKUP<\/h2>\n\n\n\n

For our example, we will use the table with students and their grades<\/strong> from different subjects, ranging from 50 to 100<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We will first use the VLOOKUP<\/strong> to find a certain result from this table. VLOOKUP stands for Vertical Lookup<\/strong> and it searches the value in the column located leftmost in a table. Then it returns the value from a designated column in that same row. The syntax is :<\/p>\n\n\n\n

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/code><\/pre>\n\n\n\n
And the explanation of these values is as follows:<\/p>\n\n\n\n
    \n
  • lookup_value:<\/strong> The value that the user is searching for in the leftmost column<\/strong> of the table.<\/li>\n\n\n\n
  • table_array:<\/strong> The range where the data is stored.<\/li>\n\n\n\n
  • col_index_num:<\/strong> Column number<\/strong> (counting from the leftmost column of the table_array<\/strong>) from where we retrieve the data.<\/li>\n\n\n\n
  • range_lookup (optional):<\/strong> TRUE or FALSE (1 or 0) parameter<\/strong>. If it returns TRUE (or 1)<\/strong>, the function performs an approximate match<\/strong> (sorted data required).<\/strong> If the FALSE (or 0) is returned, it performs an exact match<\/strong>.<\/li>\n<\/ul>\n\n\n\n
    If we want to find the grade for Jack from Geography<\/strong>, we can use the following VLOOKUP formula<\/strong> (we will put the formula in cell F2<\/strong>):<\/p>\n\n\n\n
    =VLOOKUP(\"Jack\", A2:D6, 3, FALSE)<\/code><\/pre>\n\n\n\n
    The retrieving result will be number 56<\/strong>, which is the grade that Jack got in Geography:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    In our example, Jack is the lookup value<\/strong> (the value that we are aiming to find in the leftmost column- column A<\/strong>), A2:D6 is our range<\/strong>, where we are searching for the value, number 3 is the column index<\/strong> number, since we are aiming for Geography (column C)<\/strong>, and we enter FALSE<\/strong> because we want to retrieve the exact match.<\/p>\n\n\n\n
    Using LOOKUP<\/h2>\n\n\n\n
    For the next thing, we will use the same table to show the LOOKUP function<\/strong>. This function is more generic and can perform horizontal and vertical lookups<\/strong>. But, for it to work, data has to be sorted in ascending order<\/strong>.<\/p>\n\n\n\n
    The syntax of a regular LOOKUP<\/strong> looks like this:<\/p>\n\n\n\n
      \n
    • lookup_value:<\/strong> The value that we are searching for in lookup_vector<\/strong>.<\/li>\n\n\n\n
    • lookup_vector:<\/strong> Range that has the cell that we are looking for.<\/li>\n\n\n\n
    • result_vector (optional)<\/strong>: The range of cells that contains the values you want to return. If omitted, the function will return the corresponding value from the lookup_vector<\/strong>.<\/li>\n<\/ul>\n\n\n\n
      Since the names in our table are not ordered in ascending order<\/strong>, we need to do it ourselves. We will select the data in the first row, then go to Data >> Filter<\/strong>. After that, we will choose Sort A to Z<\/strong> in the dropdown of the first column<\/strong>:<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      When we do this, we will have our data in the right order<\/strong>:<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Now we can use the LOOKUP function<\/strong> to find the grade in Math from Monica<\/strong>. We will insert the following formula in cell F2<\/strong>:<\/p>\n\n\n\n
      =LOOKUP(\"Monica\", A2:A6, B2:B6)<\/code><\/pre>\n\n\n\n
      And we will get the proper number- 97<\/strong>:<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Difference Between LOOKUP and VLOOKUP<\/h2>\n\n\n\n
      Looking at these two formulas, they can get us pretty similar results, but they are obviously different. These are the key differences<\/strong> between the two:<\/p>\n\n\n\n
        \n
      1. LOOKUP <\/strong>can deal with both vertical and horizontal data (lookups)<\/strong> if the data is sorted in ascending order<\/strong>. VLOOKUP is designed specifically for vertical lookups<\/strong>.<\/li>\n\n\n\n
      2. VLOOKUP cannot function without a column number<\/strong> being specified. This column number serves the purpose of retrieving the value. In our example, it was column 3, where the Geography is located. LOOKUP does not require this particular parameter to function<\/strong>.<\/li>\n\n\n\n
      3. It is easier to use VLOOKUP<\/strong> when the data is organized<\/strong> in a table with specific columns. LOOKUP is more flexible<\/strong>, but the downside<\/strong> is that it the data always needs to be sorted.<\/li>\n<\/ol>\n\n\n\n
        For a general conclusion, if we are dealing with a specific value in the table<\/strong> that is lined vertically<\/strong>, VLOOKUP is a clear choice<\/strong>. However, if we need to be more flexible<\/strong> and we have data sorted out<\/strong>, the LOOKUP function<\/strong> is a better choice, especially as it works with vertical and horizontal lookups.<\/p>\n","protected":false},"excerpt":{"rendered":"
        VLOOKUP is one of the most widely used formulas in Excel. A similar formula, from the same family for that matter, is LOOKUP,…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"\nDifference Between LOOKUP and VLOOKUP Functions<\/title>\n<meta name=\"description\" content=\"Download the file to learn about the difference between VLOOKUP and LOOKUP functions in Excel. Understand their core functionality and syntax.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Difference Between LOOKUP and VLOOKUP Functions\" \/>\n<meta property=\"og:description\" content=\"Download the file to learn about the difference between VLOOKUP and LOOKUP functions in Excel. Understand their core functionality and syntax.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T09:30:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Difference Between LOOKUP and VLOOKUP Functions\",\"datePublished\":\"2023-07-27T09:30:18+00:00\",\"dateModified\":\"2024-02-19T14:52:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/\"},\"wordCount\":708,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png\",\"keywords\":[\"file\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/\",\"name\":\"Difference Between LOOKUP and VLOOKUP Functions\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png\",\"datePublished\":\"2023-07-27T09:30:18+00:00\",\"dateModified\":\"2024-02-19T14:52:07+00:00\",\"description\":\"Download the file to learn about the difference between VLOOKUP and LOOKUP functions in Excel. Understand their core functionality and syntax.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png\",\"width\":382,\"height\":195},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Difference Between LOOKUP and VLOOKUP Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Difference Between LOOKUP and VLOOKUP Functions","description":"Download the file to learn about the difference between VLOOKUP and LOOKUP functions in Excel. Understand their core functionality and syntax.","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:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/","og_locale":"en_US","og_type":"article","og_title":"Difference Between LOOKUP and VLOOKUP Functions","og_description":"Download the file to learn about the difference between VLOOKUP and LOOKUP functions in Excel. Understand their core functionality and syntax.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/","article_published_time":"2023-07-27T09:30:18+00:00","article_modified_time":"2024-02-19T14:52:07+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Difference Between LOOKUP and VLOOKUP Functions","datePublished":"2023-07-27T09:30:18+00:00","dateModified":"2024-02-19T14:52:07+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/"},"wordCount":708,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png","keywords":["file"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/","url":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/","name":"Difference Between LOOKUP and VLOOKUP Functions","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png","datePublished":"2023-07-27T09:30:18+00:00","dateModified":"2024-02-19T14:52:07+00:00","description":"Download the file to learn about the difference between VLOOKUP and LOOKUP functions in Excel. Understand their core functionality and syntax.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16108-1.png","width":382,"height":195},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/difference-between-lookup-and-vlookup-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Difference Between LOOKUP and VLOOKUP Functions"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16108"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=16108"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16108\/revisions"}],"predecessor-version":[{"id":16117,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16108\/revisions\/16117"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=16108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=16108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=16108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}