Hello

I am struggling to complete a formula that returns the data in sheet1 a2 if 2 other references are correct . can anyone help with the end part please

=IF(AND(SHEET2!C3<>SHEET1!A4,SHEET1!A7=TODAY),"I want the data in sheet1A2 returned here")

Regards