![]() For this, go to the first cell of the Range column and click on Insert Function to open the Vlookup Argument Box as shown below. ![]() ![]() This process of looking up the values from the second of different sources of data with already mapped data is called Vlookup Table Array. Now drag the applied Vlookup formula to the below cells as shown below.ĭo the same procedure for the Product class as shown below.ĭrag the same formula in cell C2 to cell 9.įor Range and Incentive columns, we need to map the existing data, which we have just looked up from Table 1 with the data available in Table 2. Select the range from Table 1 and click on Ok once done. After that, click on Ok.Īfter that, we will get the Function Arguments box of Vlookup, as shown below. Now from there, under Select for a function: window type ALL or search VLOOKUP as shown below. ![]() Now go to the cell where we need to see the result and select the Insert Function option, which is just beside the Formula Bar. And the second table has the range of quantity sold with the incentive which is allotted to different quantity sold range as shown below.Īnd with the help of this data, we need to map and create another table in the respective column in below table. The first table has the Owner’s name and the quantity sold by them for the respective product class. You can download this VLOOKUP Table Array Template here – VLOOKUP Table Array Template Example #1 – Mapping and Creating Table
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |