Index & Match - fill table with unique values

Hi everyone, been stretching my formulas (googling) to the limits ...

I'm trying to fill a table column with unique matching values from another table. At the moment I'm getting the column to fill with the first value from the reference table over and over again, when really I only want unique matching values until the INDEX & MATCH has looped through every item in the reference table I've INDEXed.

So far I have this:

=INDEX(TABLE_CONTRACTORS,MATCH($B$1,TABLE_CONTRACTORS[Project],0),MATCH("First Name",TABLE_CONTRACTORS[[#Headers],0))

---> ( $B$1 contains a reference to the project name, so it varies on every worksheet. )

How would I change this so it only returns unique values, and those values populate downwards in the column?

EDIT: I've attached a file with an example of the data, and what it should look like on the second tab, along with the result my code produces.

Any pointers on how to get this in to some kind of loop through the whole table, and then to end gracefully, would be great, thanks!

Use a normal index match to get the 1st instance and then use this array formula for the rest.
{=IFERROR(INDEX(Lookup Range,SMALL(IF(Match Range=Match too Cell,ROW(Match Range)-ROW(INDEX(Match Range,1,1))+1),Lookup Instance Cell#2)),"-")}