As usual, let’s create sample datasets

Case 1: Joining data and dream
We can easily use left_join()  in dplyr.

Case 2: But I only want Dream_Vacation
Left_join()  can do about the same as Vlookup() . But the former will bring every column in the other data set. All we need to do is to subset in the left_join()  statement.

Case 3: What if column names are different…
Suppose the other dataset only has “Nombre” column, using “Name” wouldn’t work. But making it works is very easy.

Case 4: I only need Name, Grade and Dream Vacation
We need to subset both data sets.