Index Match & Max - A Basic Example

Here is a basic index match example of how you might use Index Match in conjunction with the Match function to create a formula that will return or give you the best selling product as a result.
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!
#computertutoring

😊 Check out my website and social media to keep up to date - enjoy learning 😊

📱 http://www.computertutoring.co.uk/ 📱
📽 TikTok: thecomptutor 📽
👨‍👩‍👧‍👦 Facebook: ComputerTutoring.co.uk 👨‍👩‍👧‍👦
🦉 Twitter: CT_Tutoring 🦉
📷Instagram: computer_tutoring 📷
📌https://www.pinterest.co.uk/CT_Training/ 📌

• #education
• #index_match_example
• #using_max_to_return_a_text_result
• #index_and_match_function
• #index_and_match_excel
• #index_match_example
• #using_index_match_max
• #a_basic_index_match_example