Hello everyone,


I have this formula which works well for one individual instance. But if there are multiple occurrences for

a specific individual it will not some all their occurrences of "PAID" only the first.


{=IFERROR(INDEX('SHEET1!$F$2:$F$6000,MATCH(D6&A6&"PAID",'SHEET1!$A$2:$A$6000&'SHEET1!$B$2:$B$6000&'SHEET1!$G$2:$G$6000,0)),"")}

Any Help would be greatly appreciated.

MZING81