I realize that this is a year old but I just now finally found it and IT IS
what I have been looking for for a very long time. THANK YOU VERY MUCH!!


P.S. I voted yes on the answer.



"Teethless mama" wrote:

=INDEX(Sheet1!$C$1:$C$9,MATCH(1,INDEX((Sheet1!$A$1 :$A$9=A1)*(Sheet1!$B$1:$B$9=B1),),))

just press ENTER


"Lorderon" wrote:

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!