Return last entry in column that matches criteria

Hello - I have sheet which displays an overview of what all users have access to on the system. The formula I am working with at the moment looks at individual sheets listing which users have access to that particular system and if their name is on that system access sheet, it will pull in the system username.

My problem is sometimes I create a new username for a user, suspend their access and then create a new log-on with a new username for the same user.

I would like the formula to search for the user's name, and if it's on the sheet to return the last entry username for that user.

The formula I have at the moment shows the first entry:

=IF(COUNTIF('SYSTEM ABC'!B:B,OVERVIEW!$C8),IF(SUMPRODUCT(--('SYSTEM ABC'!B$1:B$999=OVERVIEW!$C8),--(ISBLANK('SYSTEM ABC'!G$1:G$999))),INDEX('SYSTEM ABC'!I:I,MATCH(OVERVIEW!$C8,'SYSTEM ABC'!B:B,0)),"N"),"N")

Can anyone help??

Thanks

Hi thanks for your response - I've attached a workbook to give you a better visual on what I am trying to achieve. As you can see from the example, the username is showing as "ABC1" but that username has been suspended... The correct username should be "ABC2"

Thanks

Thanks for your help