I currently have this array formula:
Formula:
Formula:
{=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
Bookmarks