I have a sheet with rows of data and I want to say if the information in column C matches a cell in a different sheet and the information in column G >0 show the what that row says in column A.
I've tried the below but they all come back as False
=IF(AND(sheet1!C:C,sheet2!D2,sheet1!G:G>0),sheet1!A:A)
I'm trying to do this in sheet2.
Thanks