Circular / Blocked Reference (Vlookup)

Joanna Chu
Joanna Chu ✭✭
edited 12/09/19 in Formulas and Functions

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
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!