Forum Discussion
Jared_Bold-Gooding
May 07, 2025Copper Contributor
Using IF, INDEX, & MATCH for complex lookup
Hi folks, I've been trying to figure out a bit of a (seemingly) complex IF, INDEX, & MATCH statement to achieve some reporting on raw data that I'm gathering, but can't quite seem to figure it out, ...
Riny_van_Eekelen
May 08, 2025Platinum Contributor
Difficult to visualize what you are doing, but the formula attempts to return a result in multiple cells at once. One or more cells in that so-called spill range aren't empty. That's causing the spill error. Just empty those cells and see if the formula returns the correct result. If not, come back and show a bit more with screenshots. Preferable, share a link that gives access to your file on OneDrive or similar.