Forum Discussion
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, ...
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.