Circular / Blocked Reference (Vlookup)

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?

Find more posts tagged with

Sheets

Sharing and Collaboration

Formulas

Reports

Support

Solution Center

Cell linking

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.