Skip to content
TechnoLearnAcademy
TECHNOLEARN
Menu
Home
About us
Trainer
Contact us
Fee
Login
Register
Home
Previous
Next
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.
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS SQL
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
Scroll to Top