Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to use MATCH. Function in Microsoft Excel?

user-image
Question added by Bilal Shah Hashmi , Computer Operator , College
Date Posted: 2017/06/13
oshin kayode
by oshin kayode , Security , Unilever and Lipton Gulf

The MATCH function searches for a specified item in a range of cells and then returns the relative position of that item in the range. For example, if the range A1: A3 contains the values 5, 25, and 38, then the formula =MATCH (25, A1: A3,0) returns the number 2 because 25 is the second item in the range.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.