How can I pull data from another sheet using Index(Collect?
I am trying to integrate an INDEX(COLLECT function into an existing sheet, but I am having issues with the formula.
I am building a report template and am trying to pull equipment assignments from another sheet. So, if I type in the project name into my report template, I want to auto-populate the 'PCR' (internal equipment assignment) that's currently assigned to that project from my production calendar sheet.
I'm not 100% sure if the INDEX(COLLECT is the right function, but I am struggling to get this to work.
Thanks in advance for the help!
Help Article Resources
Check out the Formula Handbook template!