Course Content

  • Formula With Solution

Course Content


The MATCH function searches a range of cells for a specified item and returns its relative position within the range. If the values 5, 25, and 38 are in the range A1:A3, the formula =MATCH(25,A1:A3,0) produces the number 2, because 25 is the second item in the range.

Selecting both lists and then clicking Conditional Formatting -> Highlight cells rules -> Duplicate Values is the quickest approach to find everything about them (Excel 2007). As a result, the values that are the same in both lists are highlighted.

The MATCH function in Google Sheets displays the relative location of an item inside a range of cells. In other words, if you want to know where a specific number is in a range or array, MATCH will tell you where it is.

If you believe the data is in the spreadsheet but MATCH can't find it, it's possible that it's because: The cell contains unusual characters or hidden spaces. It's possible that the cell isn't formatted correctly. The cell, for example, may contain numerical numbers yet be styled as Text.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere