hello,
i am trying to get my target with two way lookup and i need get result in
Sheet2 C1

Sheet1 lookup
A-col, a1 = japan B_col, b1 = tokyo C_col, c1 = good
Sheet2 match
A-col, a1 = japan B_col, b1 = tokyo C_col, C1 = good <-- result

now i am using this:
=INDEX(Sheet1!$A$1:$A$2000,MATCH(1,(Sheet2!A1=Shee t1!$A$1:$A$2000)*(Sheet2!N20=Sheet1!$B$1:$B$2000), 3))

Thanks in advance