Multiple IF conditions in Excel

my question is as follows: How can I carry out multiple IF conditions in Excel, I would like to do this in one cell.

IF Client (in Table 1) = Client (in the current table) AND Flag (in Table 1) = "1" THEN print out the Details (from Table1) ELSE print out "Other"

I thought that this would work: =IF(AND(Table1[Client]=[@Client], Table1[flag]="1"),Table1[Details],"Other")

However everything comes out as "Other", even if the conditions are met. What am I doing wrong?