Referencing a cell in a Table in Google sheets

[Yash Ganthe]

Google sheets have introduced the Tables feature. We can now refer to an entire column using Employees[Name] . Excel had this feature since long. In Excel you can even reference individual cells on a given row such as MATCH(Employees[@Name], Employess[Name],0). The @ implies we are working on the present row and looking for a single cell. This does not seem to work in Google sheets. It shows an error. Is anyone aware of how cells can be referenced in a Table using name of the column?

I have created an example at:

https://docs.google.com/spreadsheets/d/1i3ZCE_9IvVyhrb-uK-ofMT3f0H_En1SfLSjbC8oyZlk/edit?usp=drive_link