Comparing 2 parameters from both the sheets and populating data

[ansh200431]

There are 2 sheets Sheet 1 and Sheet 2.In sheet 2(Master sheet), there are 3 columns A, B and C.In Sheet 1, we need to calculate A and B based on certain parameters...Based on the value of A and B on Sheet 1 and comparing it with value of A and B in Master sheet(Sheet 2), we need to populate the value C in Sheet 1..


If, there is one parameter..VLook Up would have been useful


I have used below formaula but not working


=IFERROR(INDEX(Sheet2!C4:C73,MATCH(1,(Sheet1!W11=Sheet2!A4:A73)*(Sheet1!U11=Sheet2!B4:B73),0)),"NO MATCH")