Index Match Formula Help
Newbie struggling with a formula. I have two sheets. In the main sheet the Intake Number is auto populated. In the second sheet, staff will input the Intake Number- the intake numbers may not be in consecutive order on this sheet as a result like they are on the main sheet. They will also provide notes on the case (column titled: Investigator Updates) or attachments.
I want to create a formula that matches the Intake Number in both sheets and then returns the Investigator Updates to the main sheet on the correct row.
Everything I am trying with Match and Index isn't giving me anything!
(and can I return attachments to the main sheet?- what would I do for that?)