Function Keeps Breaking

Sarah Underwood

Hello - I am doing the INDEX + Match functions and it works for a day or two then it breaks again. Am I doing something wrong?

I am the owner of the current sheet and pulling data from a sheet that I do not own but I am the admin on.

Mark Cronk

Hi @Sarah Underwood ,

Is someone else making changes to the base sheet that impact your data ranges? From within your formula highlight a portion of the range until you see the option "Edit Reference" and click it. Is it the right range? Not sure what else could be going on.

Mark

Sarah Underwood

Hi @Mark Cronk - when I update it the range is correct. But yes, it is being updated on the other sheet and my plan is to pull all the updated data through to my sheet. So when the data is updated on the other sheet the function no longer works.