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

Description Usage Arguments Value Author(s) See Also Examples

View source: R/VLOOKUP.R

Description

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

Usage

1
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, njbultman74@gmail.com, September 2020

See Also

merge

Examples

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

njbultman/xlsxFunctions documentation built on March 19, 2021, 6:54 p.m.