Computer Tutoring Logo
Est. 2002
Menu Button

Index Match Example - Returning the best selling product

Share

Using Index Match with Max to return best seller

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 the MAX function along with the INDEX MATCH function to return the best selling ice cream flavour. Using INDEX MATCH in conjunction with MAX 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!


At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

For more details, please read our full Privacy Policy.