MATCH: Basic MATCH function from excel

In ExcelFunctionsR: Imports Excel Functions to R

Description

It acts similiarly to Excel's MATCH function. It matches the value in the array.

Usage

MATCH(lookup_value, lookup_array)

Arguments

lookup_value	what value to lookup
lookup_array	Where should it lookup the value

Value

This example gives us the first index of an array where Species is virginica. Function will always return numeric.

Examples

MATCH("virginica",iris$Species)

ExcelFunctionsR documentation built on July 1, 2020, 8:35 p.m.