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