VLOOKUP: Find/Return Values From Matching Rows in Data Frame.

In njbultman/xlsxFunctions: Use Common Microsoft Excel Functions in R

Description

Finds matching rows in specific column of data frame that matches the values specified.

Usage

VLOOKUP(lookup_vector, lookup_df, join_col_name, column_index)

Arguments

lookup_vector	Values that you would like to join on.
lookup_df	Data frame that contains values in lookup_vector and other values you would like to connect.
join_col_name	Name of the column (as a string) that has values from lookup_vector.
column_index	Column in data frame that you would like returned once lookup value is found in lookup_df.

Value

Dataframe of returning values matching the lookup vector as well as the lookup vector values.

Author(s)

Nick Bultman, [e-mail], September 2020

See Also

merge

Examples

VLOOKUP(c("Nick", "Jake", "Tyler", "Nate"), data.frame(name = c("Nick", "Jake", "Tyler", "Nate"), number = 1:4), "name", 2)

njbultman/xlsxFunctions documentation built on Aug. 8, 2021, 3:14 p.m.