This should be placed in A3 of Sheet1:

=IF(A2=Sheet2!B2,Sheet2!B3,"")


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Satnam Randhawa" wrote in
message ...
I want to confirm that if a2 in sheet 1 is equal to b2 in sheet2 then a3 in
sheet1 should be equal to b3 in sheet2. I am trying to use the if and then
conditions for the same but i believe i dont know the right syntax to get
there.