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

Hi,
Check VLOOKUP function.

Insert extra column (A) into your second table and in first cell (A1?) put

=Vlookup(b1,$x$1:$y$100,2)

where $X$1:$Y$100 is the data in "table 1" i.e. contains DD Dog etc

Copy this formula down for all entries in table 2.

It will use the abbrevation e.g "dd" from table 2 to look up the
corresponding value in table 1 and select the second entry (the 2 is the
parameter for this) i.e "dd" will select "Dog."

HTH

" wrote:

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