Index Function Avoiding Duplicates From Dynamic Array

Hello Everyone,      I'm working on a sheet for work and cannot seem to figure this out. I'm hoping someone can offer some help:   I have a dynamic data sheet with all my data on the same page. ...