Structured tables are great and they save a lot of time, but if you try to lock structured references and replicate the formula along other columns, you will see that it won’t work, the formula will change the column reference automatically. There is no “official” answer from Microsoft to this missfeature. (not that I’ve found), but I’ve found a trick to bypass this.
Use the INDIRECT function, so Excel won’t change the reference. The formula below would change the Name reference if replicated along other columns.
=IF([@Name]="Lucas";"Yes";"No")
But using a INDIRECT function, you will be able to replicate the formula along other columns without changing the Name reference (or any other you want).
=IF(INDIRECT("Table[@Name]")="Lucas";"Yes";"No")