I have been using this function "=LOOKUP(B3;$Data.A2;B6)" for a year or so, but now it is not working. It will work properly is the data table is on the same Sheet but not when I use the "$Data." to access data on another sheet in the same workbook.

The function is on sheet named 'Enter' and the table is on sheet "Data".