Index Match Example - Excel 2016

Have you heard of the Index Match function? Now doubt one of the Excel guru's at work has told you how they never use VLookup and will go with Index Match every time. When they continue to extol the virtures of Index Match you would be forgiven for getting a little lost.

This video incorporates other functions along with the Index Match function to return the best selling ice cream flavour. You see the bonus of using Index Match over VLookup when you see how you can look up the ice cream flavours name ON THE LEFT. That's Right! You can use this function to look from Right to Left. So you're no longer restricted to having the Lookup column being the Left most column. Fantastic!