match 2 columns in sheet 1 with the columns in sheet 2 and return the value of column 3 of the sheet 1 : I have 2 sheets. sheet 1 contains col 1,col 2, col 3. Similary, sheet 2 has col 1, col 2, col 3. I wish to match a produce a output in this way:

if ((col 1(of sheet 1)==col 1 (of sheet 2)) && (col 2(of sheet 1)==col 2 (of sheet 2))),
 
then col 3(of sheet 1)= col 3 (of sheet 2)

(I hope I have made the question  clear)