Software - Micro Learning - INDEX and MATCH with Multiple Criteria in Excel

Content
2 modules
Difficulty
Basic
Rating
Course Length
15 mins
Instructor
Pantry of Knowledge

Description

This lesson will support you in performing complex two-way lookups with ease. We’ll explore the mechanics of the two-way lookup using the combination of INDEX and MATCH functions. The INDEX function will help us retrieve the sales value from the specified array, while the MATCH function will allow us to find the positions of the selected company and month within their respective lists. Combining these functions makes our formula flexible enough to handle various combinations, ensuring accurate and efficient data retrieval.

Objectives

KEY OBJECTIVES

  • Perform a two-way lookup using INDEX and MATCH functions with multiple criteria
  • Dynamically retrieve specific data from a dataset based on user-selected inputs

Certificate

By completing/passing this course, you will attain the certificate POK Software Skills Certificate

Learning Credits

CEU
0.25

Badges

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value') }}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved_for_selected_score_and_over')}}

{{ vm.percentage_badges[vm.selected_badge].greater_than_or_equal }}%

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value')}}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved') }}

{{ vm.helper.t('lup.gamification.learning_awards.on_course_completion') }}
1.
Software - Micro Learning - INDEX and MATCH with Multiple Criteria in Excel
{{ vm.helper.t('courses.scorm') }}
2.
Software - Micro Learning - INDEX and MATCH with Multiple Criteria in Excel
{{ vm.helper.t('courses.survey') }}
 
Added 2 months ago, by Tricia

Shopping Cart

Your cart is empty