Assuming your first data is on row 2.

Put this formula on your worksheet 2, column 3.

=IF(AND(A2=Sheet1!A2,B2=Sheet1!B2),Sheet1!C2,"")

and copy it all the way down for all rows.


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=533039