Friday, 1 August 2014

Match Formula in Excel

 Match Formula in Excel:

 Match Formula in Excel

 MATCH(lookup_value, lookup_array, [match_type])

    lookup_value : Required. The value that you want to match in lookup_array. For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.

The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

    lookup_array:  Required. The range of cells being searched.
    match_type:  Optional. The number -1, 0, or 1. The match_type argument specifies how Excel matches lookup_value with values in lookup_array. The default value for this argument is 1.


Post a Comment