On Dec 26, 11:16 am, Satnam Randhawa
wrote:
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.

In A3 on sheet1, use this formula:

=IF('Sheet1'!A2='Sheet2'!B2,'Sheet2'!B3)

If A2 on sheet 1 does not equal B2 on sheet 2, this formula will
return FALSE.