I tried this but error result "#N/A"....

You probably didn't array-enter the formula properly, although I took the
pain of highlighting this step explicitly in the response.

If you did the "press CTRL+SHIFT+ENTER" bit properly, the formula should
appear wrapped with curly braces within the formula bar, viz, it should look
like this:

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

If you don't see the curlies, just re-click inside the formula bar,
re-do the CTRL+SHIFT+ENTER confirmation
Then look again that the curlies are there

If the formula is not array-entered, it will not return the correct result

Give it another try. I assure you that it works.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---