Too many Cell References Error

Chandler237162

So i am making a sheet to keep track of different devices i mangage. While doing this i ended up with a lot of duplicate columns (Ex: Description column and another column named [DESCRIPTION] with the formula "=Description@row")

Since getting the too many cell references error i deleted about half of the columns i had and all the duplicate columns i had but it is still giving me this error.

Also my reference manager is saying there are 0 cell references. What can i do to fix this?

Michelle Choate 2

Can you take a picture of your reference manager?

Chandler237162

Michelle Choate 2

Ok, what is happening here is a different error than I originally thought. What is happening is your reference area in your formula is too large. So if you are using a VLOOKUP for example and it is going across 100 columns with thousands of rows of data, sure your sheet references are only 3, but the total amount of cells references is too many.

This is why INDEX/COLLECT is better than VLOOKUP any day. What is the formula you are using that is giving this error?