=VLOOKUP(A2, Sheet1!A:B,2,False)

--
__________________________________
HTH

Bob

"Lorderon" wrote in message
...
Hi,
I have 2 worksheets "Sheet1" and "Sheet2"
"Sheet1" contains my raw data which is:
Col A Col B Col C
Dog 1 Adata
Cat 2 Bdata
Bird 3 Cdata
Dog 4 Ddata
Cat 5 Edata
Bird 6 Fdata
Dog 7 Gdata
Cat 8 Hdata
Bird 9 Idata


"Sheet2" contains my work data and I need to fill in Col C on this
worksheet:
Col A Col B Col C
Dog 4 Ddata
Cat 5 Edata
Bird 6 ???
Dog 1 ???
Cat 8 ???
Bird 3 ???
Dog 7 ???
Cat 8 ???
Bird 6 ???


So, how to get the correct result (that is fill-in the "???" items)? I
already fill-in the first 2 items on Col C, meaning it needs to find the
data
in Sheet1 that matches Col A and Col B on Sheet2, then copy teh reuslt in
Col
C on Sheet2.

How? Pls help. Thanks!