Lets say I have a table
1 2
A dd Dog
B dd Dog
C cc Cat
D cc Cat
E mm Monkey
F hh Horse
G hh Horse

Then I have another table, lets say in the same worksheet that says

1 2
A dd 1937
B cc 6846
C mm 456
D hh 22

I want to combine the info to have a table that says
Dog dd 1937
Cat cc 6846
Monkey mm 456
Horse hh 22

Can I even do this type of thing with an excel formula? I played
around with doing it in Access but the fact that the first table has a
lot of duplicates throws the queries off, so I would have to remove all
the duplicates in the first table before using access. It seems like
using one of the lookup formulas in excel would work, but I am going
crazy trying to figure it out.

Thanks,
Andrew V. Romero