Try...

Sheet2!C1, copied down:

=INDEX(Sheet1!$C$1:$C$100,MATCH(1,(Sheet1!$A$1:$A$ 100=Sheet2!A1)*(Sheet1!
$B$1:$B$100=Sheet2!B1),0))

....confirmed with CONTRO+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Adnan" wrote:

Hi,
while using Excel i came across with the problem of comparisions.

In Sheet 1 i have three Columns (A, B & C ) and on Sheet 2 i have two
columns A& B. I need to match sheet 1 column A & B with Column Sheet 2 A & B
if both matched then Sheet 1 Column C text will be placed in sheet 2 column c
.

regards