I have a situation where list A has lookup column which looks for data in another list B which has 25000 items, when editing item lookup columns are greyed out, seems its because of exceeding threshold values. Can we use calculated field to achieve this or is therer any other way dealing with this issue ?
Unfortunately, you cannot use Calculated Columns with lookup fields