Multiple Lookups & SUM without using VLookup HD

Vlookup and HLookup find the first match and then stop. But what if you wanted to collect all the entries in a list that match a criteria and then perform some other operations on them as well? Well this is where this tutorial comes in. This uses rows and aggregate and index functions to collects a list of dealers working with a particular sales persons and then also gives the total revenue for each sales person. If you liked this video, then please kindly give its a thumbs up and if you want to see more videos like this then please subscribe