Circular / Blocked Reference (Vlookup)

Joanna Chu

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?

L_123

Gotta post the formula or we can't help.  Without seeing it, the only think I can think of is trying index(match()) instead of vlookup.

 

Screenshots would also help.