It sounds like you are looking for a "join" operation, take a look at the dplyr package.
Mutating joins add columns from y to x, matching observations based on
the keys. There are four mutating joins: the inner join, and the three outer
joins.
Inner join
An inner_join() only keeps observations from x that have a matching key
in y.
The...
That is because the preferred method for asking questions here is with a proper Reproducible Example, take a look at this guide to learn how to create one.
A minimal reproducible example consists of the following items:
A minimal dataset, necessary to reproduce the issue
The minimal runnable code necessary to reproduce the issue, which can be run
on the given dataset, and including the necessary information on the used packages.
Let's quickly go over each one of these with examples: