Hi,
I tried this but error result "#N/A"....Then I tried the suggestion
"=INDEX(Sheet1!$C$1:$C$9,MATCH(1,INDEX((Sheet1!$A$ 1:$A$9=A1)*(Sheet1!$B$1:$B$9=B1),),))
" and it worked!

Thanks anyway...


"Max" wrote:

One way is to use a multi-criteria index/match, array-entered

In Sheet2,
Paste this into C1's formula bar,
then press CTRL+SHIFT+ENTER to array-enter the formula:
=INDEX(Sheet1!C$1:C$9,MATCH(1,(Sheet1!A$1:A$9=A1)* (Sheet1!B$1:B$9=B1),0))
Copy C1 down. Adapt the ranges to suit the actual extents of your data.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Lorderon" wrote:
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!