Forum Discussion
Solved
SPILL Error on IF function
Hi All, I'm having trouble locating the error in my formula. I have a data sheet '012021' where column E is a list of locations (some duplicated) and f-g a various number values. The duplicate ci...
- =IF( column, something) returns as many elements as you have them in entire column.
Ah ok that's the part I was missing. I didn't realize IF functions iterate and return through each instance.
Thank you Sergei!
For anyone that runs into this I resolved using XLOOKUP (which I had originally tried but other data issues made that not an option. Luckily those data issues aren't any issue anymore.
Latest formula also returns 1 million values array in each element of it we have text if condition is met for related row in columns E and F, otherwise FALSE.
=IF( column, something) returns as many elements as you have them in entire column.
=IF( column, something) returns as many elements as you have them in entire column.
Ah ok that's the part I was missing. I didn't realize IF functions iterate and return through each instance.
Thank you Sergei!
For anyone that runs into this I resolved using XLOOKUP (which I had originally tried but other data issues made that not an option. Luckily those data issues aren't any issue anymore.
Ah ok that's the part I was missing. I didn't realize IF functions iterate and return through each instance.
Thank you Sergei!
For anyone that runs into this I resolved using XLOOKUP (which I had originally tried but other data issues made that not an option. Luckily those data issues aren't any issue anymore.