?B?TG9yZGVyb24=?= wrote in
:

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 (expected result) on Col C, meaning
it needs to find the data
in Sheet1 that matches Col A and Col B on Sheet2, then copy the result
in Col C on Sheet2.

How? Pls help. Thanks!



from the data given, it looks likeyou can do a vlookup() based on column
B only.
if your data starts in row 1 and ends row 9

=VLOOKUP(B1,Sheet1!$B$1:$C$9,2,FALSE)

then you should be able to put this in your c column and copy&paste down.