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)