{"id":1598,"date":"2021-03-01T16:41:46","date_gmt":"2021-03-01T15:41:46","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1598"},"modified":"2023-11-29T23:21:17","modified_gmt":"2023-11-29T22:21:17","slug":"vlookup-in-multiple-excel-sheets","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-in-multiple-excel-sheets\/","title":{"rendered":"How to Use VLOOKUP between Sheets"},"content":{"rendered":"<p>In many cases, your data may be connected but spread out among different sheets. With the help of VLOOKUP between sheets, you can<strong> overcome this obstacle and extract corresponding data<\/strong> from different sheets.<\/p>\n<p>This gives you the freedom to have <strong>data in multiple sheets and not face restrictions<\/strong> in using them.<\/p>\n<p>Before we move forward, let&#8217;s understand how to use VLOOKUP between sheets:<\/p>\n<ul>\n<li><a href=\"#vlookup-syntax\"><strong>VLOOKUP Syntax<\/strong><\/a><\/li>\n<li><a href=\"#vlookup-from-another-sheet\"><strong>VLOOKUP from another sheet<\/strong><\/a><\/li>\n<li><a href=\"#vlookup-from-another-workbook\"><strong>VLOOKUP from another workbook<\/strong><\/a><\/li>\n<\/ul>\n<p>Look at each of these topics one-by-one!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #008000;\"><a id=\"vlookup-syntax\"><\/a>VLOOKUP Syntax<\/span><\/h3>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Searches for a value in the first column of a table array and returns a value in the same row from another sheet\u00b4s column (to the right) in the table array.<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=VLOOKUP(<span style=\"color: #0000ff;\">lookup_value<\/span>, <span style=\"color: #ff6600;\">table_array<\/span>, <span style=\"color: #008000;\">col_index_num<\/span>, <span style=\"color: #ff00ff;\">[range_lookup]<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=VLOOKUP(<span style=\"color: #0000ff;\">this value in Sheet1<\/span>, <span style=\"color: #ff6600;\">in this list in Sheet2<\/span>, <span style=\"color: #008000;\">and get me value in this column in Sheet2<\/span>, <span style=\"color: #ff00ff;\">Exact Match\/FALSE\/0]<\/span>)<\/p>\n<p>Sometimes you are faced with a situation where you have a list of data and you want to bring in complementary data from a different sheet within the same workbook.<\/p>\n<p>Let&#8217;s say that you have a list of &#8220;items&#8221; in a table within <em>Sheet1<\/em> and you want to bring in their corresponding &#8220;item id&#8217;s&#8221; from <em>Sheet2<\/em>.<\/p>\n<p>You can manually copy and paste the item id&#8217;s from <em>Sheet2<\/em> to <em>Sheet1<\/em> but that would take too long and you are also prone to errors.<\/p>\n<p>The quick and error-proof way is by using the VLOOKUP function.<\/p>\n\n<h3>So, let&#8217;s dive in and learn how to use VLOOKUP between sheets!<\/h3>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #008000;\"><strong><a id=\"vlookup-from-another-sheet\"><\/a>VLOOKUP from another sheet<\/strong><\/span><\/h3>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/9XbCILGvL3A\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/9XbCILGvL3A?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span>\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>Follow the<strong> step-by-step tutorial<\/strong> on how to VLOOKUP\u00a0for multiple sheets with example and <strong>download this Excel workbook<\/strong> to practice along:<\/p>\n<p><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Vlookup_Different-Sheetv2s.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Vlookup_Different-Sheetv2s.xlsx<\/span><\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We enter the VLOOKUP function in the blank cell where we need to extract the data<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=VLOOKUP(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.27-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22792\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.27-PM.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"758\" height=\"371\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.27-PM.png 758w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.27-PM-300x147.png 300w\" sizes=\"(max-width: 758px) 100vw, 758px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Enter the <strong>first argument<\/strong> for VLOOKUP &#8211; <strong>Lookup_value<\/strong><\/p>\n<p><em>What is the value that you want to look for?<\/em><\/p>\n<p>In our example, it is Television, so select that in the \u201cItems\u201d column<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP<\/span><span style=\"color: #0000ff;\">(B14,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.49-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22791\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.49-PM.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"766\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.49-PM.png 766w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-6.58.49-PM-300x149.png 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>Enter the <strong>second\u00a0argument<\/strong> for VLOOKUP &#8211; <strong>Table_array<\/strong><\/p>\n<p><em>What is the table or range that contains your data?<\/em><\/p>\n<p>Select the Stock inventory table in the stock list sheet so that the VLOOKUP formula will search there<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(B14,<\/span><span style=\"color: #0000ff;\">&#8216;STOCK LIST&#8217;!D9:E23,<\/span><\/h3>\n<p>Ensure that you press\u00a0F4 so that you can lock the table range.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(B14,<\/span><span style=\"color: #0000ff;\">&#8216;STOCK LIST&#8217;!$D$9:$E$23,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.14.07-PM-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22795\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.14.07-PM-1.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"798\" height=\"531\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.14.07-PM-1.png 798w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.14.07-PM-1-300x200.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.14.07-PM-1-768x511.png 768w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>Enter the <strong>third\u00a0argument<\/strong> for VLOOKUP &#8211; <strong>Col_index_num<\/strong><\/p>\n<p><em>What is the column that you want to retrieve the value from?<\/em><\/p>\n<p>Since we want to retrieve the item id we will write 2, as the item id is the second column in the table array that we selected<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(B14,&#8217;STOCK LIST&#8217;!D9:G23,<\/span><span style=\"color: #0000ff;\">2<\/span><\/h3>\n<p><strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.48-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22787\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.48-PM.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"759\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.48-PM.png 759w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.48-PM-300x143.png 300w\" sizes=\"(max-width: 759px) 100vw, 759px\" \/><\/a><\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>Enter the <strong>fourth argument<\/strong> for VLOOKUP &#8211; <strong>Range_lookup<\/strong><\/p>\n<p><em>What kind of matching do you need?<\/em><\/p>\n<p>We want an exact match of the Television text so make sure FALSE OR 0 is selected.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(B14,&#8217;STOCK LIST&#8217;!D9:G23,2,<\/span><span style=\"color: #0000ff;\">0)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.56-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22789\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.56-PM.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"762\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.56-PM.png 762w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.01.56-PM-300x142.png 300w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/a><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p>You now have all of the results!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.17.10-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22796\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.17.10-PM.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"560\" height=\"287\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.17.10-PM.png 560w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-2021-02-28-at-7.17.10-PM-300x154.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a><\/p>\n<p>In this example, you have learned how to pull data from another worksheet in the same workbook using VLOOKUP from multiple sheets. Excel also <strong>allows you to get data from another workbook<\/strong> from your computer.<\/p>\n<p>Let&#8217;s see how that is done!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #008000;\"><strong><a id=\"vlookup-from-another-workbook\"><\/a>VLOOKUP from another workbook<\/strong><\/span><\/h3>\n<p>Suppose you have monthly sales data in one workbook and you have the employee name and data in another workbook.<\/p>\n<p>You have to <strong>link these two workbooks using VLOOKUP to extract values<\/strong> for a better and cohesive database.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-211.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone wp-image-22802\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-211.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"408\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-211.png 883w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-211-300x225.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-211-768x575.png 768w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/a> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-213.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone wp-image-22803\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-213.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"407\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-213.png 881w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-213-300x226.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-213-768x578.png 768w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>In this tutorial, we will show you how you can use VLOOKUP across different Excel workbooks and link and extract data easily.<\/p>\n<p><strong><span style=\"color: #ff0000;\">Step 1: <\/span><\/strong>We <strong>enter the VLOOKUP function<\/strong> in the blank cell where we need to extract the data<\/p>\n<p>This is the cell where we want the corresponding data. In our case, this is the department of the employee in cell C15.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=VLOOKUP(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-214.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22805\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-214.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"630\" height=\"337\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-214.png 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-214-300x160.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">Step 2:<\/span><\/strong> Enter the<strong> first argument<\/strong> of the VLOOKUP function &#8211; <strong>Lookup_value<\/strong><\/p>\n<p><em>What is the value that you want to look for?<\/em><\/p>\n<p>It is the value to be found in the first column of the table. It can be a value, text string, or reference.<\/p>\n<p>In our example, it is Mark, so select that in the \u201cEmployees\u201d column<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(<\/span><span style=\"color: #0000ff;\">B15,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-215.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22806\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-215.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"621\" height=\"332\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-215.png 621w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-215-300x160.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">Step 3:<\/span><\/strong> Enter the<strong> second argument<\/strong> of the VLOOKUP function &#8211; <strong>Table_array<\/strong><\/p>\n<p><em>What is the table or range that contains your data?<\/em><\/p>\n<p><strong>It is a table of logical values, texts, numbers from which the data is retrieved<\/strong><\/p>\n<p>Here you need to go to the workbook where your employees&#8217; data is stored so that we can get the name of the department they are associated with.<\/p>\n<p>Select the data table containing the names and departments of the employees.<\/p>\n<p>Ensure that you<strong> press F4<\/strong> so that you can lock the table range. You will be sure the <strong>range is locked when $ signs appear<\/strong>.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(B15,<\/span><span style=\"color: #0000ff;\">&#8216;[Employee Data.xlsx]employee list&#8217;!$D$9:$G$23<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-216.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22807\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-216.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"770\" height=\"543\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-216.png 770w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-216-300x212.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-216-768x542.png 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Notice how the <strong>name of the different workbooks appears between square brackets<\/strong>. This is the indication that the reference is from another workbook.<\/p>\n<p>So if you are typing out the formula <strong>make sure to include the square brackets<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">Step 4:<\/span><\/strong> Enter the<strong> third argument<\/strong> of the VLOOKUP function &#8211; <strong>Col_index_num<\/strong><\/p>\n<p><em>What is the column that you want to retrieve the value from?<\/em><\/p>\n<p><strong>It is the column number from which the matching value should be returned.<\/strong><\/p>\n<p>Since we want to retrieve the Department name we will write 2, as the department name is the second column in the table array that we selected.<\/p>\n<p>Similarly, if we wanted to extract the employee code, we would type 3 here as employee code is in the third column of the table that we selected.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(B15,'[Employee Data.xlsx]employee list&#8217;!$D$9:$G$23,<\/span><span style=\"color: #0000ff;\">2<\/span><\/h3>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-217.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22808\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-217.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"705\" height=\"340\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-217.png 705w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-217-300x145.png 300w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">Step 5:<\/span><\/strong> Enter the<strong> fourth argument<\/strong> of the VLOOKUP function &#8211; <strong>Range_lookup<\/strong><\/p>\n<p><em>What kind of matching do you need?<\/em><\/p>\n<p><strong>To find a perfect match, we need to select FALSE here.<\/strong><\/p>\n<p>In case the data is arranged in ascending order and belongs to a certain range\/period, then TRUE should be selected to get the closest match.<\/p>\n<p>We want an exact match of Mark text so make sure FALSE or 0 is selected.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP(B15,'[Employee Data.xlsx]employee list&#8217;!$D$9:$G$23,2,<\/span><span style=\"color: #0000ff;\">0)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-219.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone size-full wp-image-22809\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-219.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"711\" height=\"337\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-219.png 711w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-219-300x142.png 300w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Apply the same formula to the <strong>rest of the cells by dragging the lower right corner downwards<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-220.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use VLOOKUP between Sheets\"  class=\"alignnone wp-image-22810 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-220.png\" alt=\"How to Use VLOOKUP between Sheets\" width=\"447\" height=\"251\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-220.png 447w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/08\/Screenshot-220-300x168.png 300w\" sizes=\"(max-width: 447px) 100vw, 447px\" \/><\/a><\/p>\n<p>This is how you can extract values using VLOOKUP in multiple sheets or multiple workbooks!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to learn more application of this versatile function &#8211; VLOOKUP!!<\/p>\n<p><span style=\"color: #000000;\"><strong>Further Learning:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlookup-function-in-excel\/\" target=\"_blank\" rel=\"noopener\">How to use the XLOOKUP function in Excel with 7 Examples!<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlookup-in-excel\/\" target=\"_blank\" rel=\"noopener\">Top 11 Examples of Using XLOOKUP in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlookup-with-multiple-criteria\/\" target=\"_blank\" rel=\"noopener\">2 Easy Methods on How to Use XLOOKUP with Multiple Criteria<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In many cases, your data may be connected but spread out among different sheets. With the help of VLOOKUP between sheets, you can overcome this obstacle and extract corresponding data from different sheets. This gives you the freedom to have data in multiple sheets and not face restrictions in using them. Before we move forward, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,11,276],"tags":[43,44],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1598"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1598"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1598\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17165"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}