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
