Thread: how to match data

Matching/adding new data

I need to do this for about 500 rows; help? Is there an easy way that I have not yet discovered?

I have a spreadsheet with Column A and Column B. I got new data via a second method. How can I match rows in column A with column A2 so I can compare existing data between Column B and Column C?

Current:
My data
Column A Column B
a 12
b 1
c 3
d 5
e 7

New
Column A2 Column C
a 10
c 3
d 3
f 0


I need:
Column A Column B Column C
a 12 10
c 3 3
d 5 3
f - 0