ExcelFunctionsR (version 0.1.4)

MATCH: Basic MATCH function from excel

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

# NOT RUN {
MATCH("virginica",iris$Species)
# }