Index Match

Index Match, King of the Lookup Function

Index Match, learn how to use it effectively to bring back data in excel. While similar to a Vlookup, in everyday use it can be faster than fumbling around with formatting your data correctly to use a vlookup.

Sumifs, Averageifs, Countifs

Advancing our Aggregation Capabilities

Using Sumifs to aggregate our data and combining it with index match to make new aggregations possible.