Matching new webform data to existing data
I have a sheet that automatically populates with data from a linked webform. This is the EOI stage. If the EOI applicant meets certain criteria those applications are sent to certain project team members for approval. Once approved by project team members the applicants are sent a round two application form. The data from the round two webform applications then automatically populate into a new sheet in the same workspace.
What I want to do is match some of the details from rows in the approved EOI applications to new data coming in from the round two applications. Are you able to advise how I would do this. At the moment the new form just creates rows below the fields that I want to match from the EOI process. I am thinking it might be the INDEX/MATCH functions at this stage and would be grateful for any assistance that could be provided.