Referencing single arbitrary cell using Excel structured reference

Solution 1:

Depending on whether you want to reference row by value in another column, or row number, you can use:

FILTER(table1[Price],table1[NAME]="orange")

OR

INDEX(table1[PRICE],2)