I think Purfleet's solution will work for you if you use his
=MATCH([@Name2],[Name2],0)
in E2 (copy down if it doesn't happen automatically).
Then refresh your qUnique table.
Leave your VLOOKUP as it is in column G.

The numbers don't have to be contiguous values for this.


Without the qUnique table, try in column G
=INDEX([Name],MATCH([@NameCode]&"N",[NameCode]&[Name3],0))