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!
We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at firstname.lastname@example.org.