I currently have this array formula:

Formula: copy to clipboard
Formula: copy to clipboard
{=IFERROR(INDEX('DROP CLIENT FCI HERE'!P:P,SMALL(IF(ISNUMBER(MATCH('DROP CLIENT FCI HERE'!L$2:L$10000,{"Initial Fee","Initial Commission"},0)),IF('DROP CLIENT FCI HERE'!T$2:T$10000=A$26,ROW('DROP CLIENT FCI HERE'!T$2:T$10000))),ROWS(B$27:B27))),"")}


This works perfectly but I want to add a condition that column N in the 'DROP CLIENT FCI HERE' which is a Payment Date, the month, must equal today's month in order to return a result. I tried adding it as an AND on the last IF condition but it didnt work.

Any help would be much appreciated!!!

Thank you so much in advance!

Alex