Could we see an example of the data you’d possibly be pulling?
> On Mar 25, 2020, at 10:51 PM, Mackenzie M. Salisbury > <suzanne.salisb...@mail.waldenu.edu> wrote: > > EXTERNAL EMAIL > > > Hi all! > I am hoping someone out there has an excel formula or script that I can use > to solve this problem: > > I have a google form and I want the data from this form to go to different > sheets (different workbooks) based on an answer to one of the questions. The > trick is that the question may have more than one answer. The data collected > includes metadata as well as files. > > Alternatively, I would settle for an excel formula that would let me import > data of a whole row, based on a partial match of information from one cell in > a specific column. > > Anyone have any ideas? > > Best, > > Mackenzie Salisbury (she, her, > hers)<https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Facademicguides.waldenu.edu%2Fdiversity-inclusion&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=RnlHPoGg8dI%2Bej6P3a8Gpnv%2FsWd4Gm8S1Qco93%2Bltqo%3D&reserved=0> > Librarian, Digital Scholarship > Walden University > Library<https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Facademicguides.waldenu.edu%2Flibrary%3Futm_source%3Doutlook%26utm_medium%3Demail%26utm_campaign%3Demail_signature&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=c4KkBBLRaXGRmkMfoClUFuSey3l1MCpXgmiOtoo%2F32o%3D&reserved=0> > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FWalden-University-Library&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=rUBY%2BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%3D&reserved=0> > > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FWalden-University-Library&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=rUBY%2BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%3D&reserved=0> > > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FWalden-University-Library&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=rUBY%2BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%3D&reserved=0>[icon_facebook]<https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FWalden-University-Library&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=rUBY%2BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%3D&reserved=0> > > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fwalden.university.library%2F&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=2pNQNcXeAJxIlnzlOuG1FFC5Lj4GfomXZJp0TelIi04%3D&reserved=0> > [icon_instagram] > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fwalden.university.library&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=eKTGbatSPtw0A9HRscmcnqaTayyoYtVlOT4XmlvgtA4%3D&reserved=0> > > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FWaldenULibrary&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=XKQc8%2FGsS7eH2SlbZQk65ofLgj%2Bzh%2FD3WGFrsDAorEE%3D&reserved=0> > [icon_twitter] > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FWaldenULibrary&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=XKQc8%2FGsS7eH2SlbZQk65ofLgj%2Bzh%2FD3WGFrsDAorEE%3D&reserved=0> > > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Facademicguides.waldenu.edu%2Flibrary%2Fstudentnews%3Futm_source%3Doutlook%26utm_medium%3Demail%26utm_campaign%3Demail_signature&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=hn%2F00LkpqKpknccg83PbW5crto8OTsJizo51KBtz7%2BI%3D&reserved=0> > [icon_libnews] > <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Facademicguides.waldenu.edu%2Flibrary%2Fstudentnews%3Futm_source%3Doutlook%26utm_medium%3Demail%26utm_campaign%3Demail_signature&data=02%7C01%7Cgpierce%40ARLINGTONVA.US%7Cf31f692a5b50420cc9c908d7d1308f58%7C803548041fdf428e9f5f5091e994cf54%7C0%7C0%7C637207878899378756&sdata=hn%2F00LkpqKpknccg83PbW5crto8OTsJizo51KBtz7%2BI%3D&reserved=0>