In the table array, select the complete table 1.Īs we want to get Quantity Sold numbers from Table1 to Table2, so we will be selecting column 4 as Col Index. For that, combine or concatenate F1 and G1 value with the help of underscore. Insert vlookup function as shown below.Īs per syntax, we need to select the lookup value in the same way we have created in table 1. Now in table 2, we will be applying Vlookup to get the value from Table 1 to Table 2. We will be able to see the final unique key column A as shown below. In the Key column, we are using an underscore as a separator. To avoid such situations, we will insert a column in the first table and make a key using the Owner name and Product columns. Now if we apply the vlookup in cell G2 to get the quantity sold for each Owner name then we will only get the first value of each owner name as the owner names are getting repeated. Each table has same headers and also has the same Owner names and Product names in the same sequence. In this, we will be seeing, how to use Vlookup to get multiple values from one table to another. You can download this VLOOKUP to Return Multiple Values Excel Template here – VLOOKUP to Return Multiple Values Excel Template Example #1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |