EXCEL MATCH
The Match is an Excel function used to locate the position of a specified item in a range.
Syntax:
=MATCH(lookup_value, lookup_array,[match_type])
Objective: Find the Position of Germany in the State Range.
Step 1:
Type = sign in cell H4.
Type Match function.
Step 2:
Type G4 in lookup_value Argument
Type “,”
Step 3:
Select range C4:C10
Type “,”
Step 4:
We are looking for the exact match
Type 0 in [match_type]
Type “)” and close the bracket
Press Enter
Conclusion: Match Function has populated the 3rd position of Germany in the State Range.
