I have a problem with 2 sheets reading each other’s data through a VLOOKUP. The same problem was posted on May 30, 2018 by scott.barrett. Obviously it is not solved.
My sheets also work perfectly for periods of time, and then start returning #circular or #blocked data without any changes to the sheets in almost every 2 weeks. All I can do is changing the VLOOKUP range "Name”, then it appears to fix the issue.
How do I solve this? Anyone have any ideas?