Hi gsrikanth,

davesexcel has given you a great solution to your problem however he didn't use the full ranges on sheet 2. Here is a minor correction to your problem.

=INDEX(Sheet2!$C$2:$C$1759,MATCH(1,(A2=Sheet2!$A$2 :$A$1759)*(B2=Sheet2!$B$2:$B$1759),0))

Again, follow the steps that he gave you and replace this formula with his.