Forum Discussion
Solved
Using array formula to populate data
I’ve tried searching for help on this but everything I find is way more complicated than what I need and I just get lost following along. This is what I’m looking for: If table titled “Applicants...
- I figured it out! Combined it with INDEX to return only the Name column. The spill error was happening because it didn’t like that I was trying to insert into a table which I wasn’t sure how to make that work. I’ll leave that for another day though!
I attempted using the FILTER formula and I received the error #SPILL! I guess the FILTER formula on its own though will not work for me since it wants to return all data not just a single piece, right? This is why you mention using dynamic array formula?
Jbuff26 Actually, that's good news. The spill error means it's working but you have cell occupying the range where the FILTER functions wants to write the results to.
Remove anything that is inside the dashed area that comes up when you select the cell with #SPILL!
- I figured it out! Combined it with INDEX to return only the Name column. The spill error was happening because it didn’t like that I was trying to insert into a table which I wasn’t sure how to make that work. I’ll leave that for another day though!
- Ok yes I see. I was trying to return the result to the first open cell in the “hired table”. So again, this is return EVERY piece of data from all columns in the Applicants table. How do I further refine to ONLY return the name to my HIRED table?