#Example of Excel Command

=VLOOKUP (value, table, col_index, [range_lookup])

#Generate similiar output in R using

  • “Merge”

=merge(Data_A, Data_B, by = c(“col_A”, “col_B”), all.x = TRUE)

  • “Match”

=match(x, table, nomatch = NA, incomparables = FALSE)

x: Values to be matched

table: Values to be matched against

nomatch: Values to return if no match

incomparables: Values that cannot be matched. If FALSE, all values can be matched