What would be the best method of mapping a attribute from one CSV to another CSV?

[Hoss2434]

I am trying to pull a attribute from one csv to another based on a primary key column. Here is an example of a before and after of what I am trying to do:

Before:

CSV 1

Primary Value	Value
1	red
2	blue
3	green

CSV 2

Primary Value	Value
1
3
3
2
2
3

After:

CSV 1

Primary Value	Value
1	red
2	blue
3	green

CSV 2

Primary Value	Value
1	red
3	green
3	green
2	blue
2	blue
3	green

Essentialy I am just trying to fill the "Value" column in CSV 2 with the attributes mapped out in CSV 1. In my actual data-set I have hundreds of values in my mapping, so I don't want to create indivudual formuals for each mapping. 

I was wondering if anyone else knew another way?

Any help would be appreciated.

Thanks!

[BS_THE_ANALYST]

@Hoss2434 I would suggest using the Join tool:

Input examples:
CSV1

CSV2:

Output (once you deselect appropriate fields):

[binuacs]

@Hoss2434 Another way of doing this with the find and replace method