I have a function pulling records by merging text from 2 other fields. Then I want to use this merged field as lookup function. I can’t because Function field can’t be Lookup field at the same time. (Yes there is a work-around by manually copying from Function cell to a staging cell that will become Lookup cell. Too much work copying every time data changes in Function cell. That means copying 100 times per day.