How to "marry" form responses with a specific person listed in another table in excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-1938796%22%20slang%3D%22en-US%22%3EHow%20to%20%22marry%22%20form%20responses%20with%20a%20specific%20person%20listed%20in%20another%20table%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938796%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help%20me%20find%20a%20solution%20to%20my%20dilemma.%26nbsp%3B%20I%20have%20an%20excel%20table%20with%20hundreds%20of%20students%2C%20from%20whom%20I%20need%20to%20collect%20a%20lot%20of%20updated%20information.%20The%20form%20was%20set%20up%20in%20google%20forms%20and%20the%20replies%20are%20saved%20in%20google%20sheets.%26nbsp%3B%20The%20time%20matching%20an%20copying%20and%20updating%20manually%20each%20applicable%20field%20with%20about%2040%20different%20columns%20from%20google%20sheet%20to%20excel%20table%20is%20horrendous.%26nbsp%3B%20Is%20there%20a%20way%20to%20%22marry%22%20the%20information%20from%20the%20google%20sheet%20to%20the%20correct%20person%20on%20the%20excel%20table%3F%3C%2FP%3E%3CP%3EI%20can%20not%20attach%20a%20sample%20because%20the%20information%20I%20am%20collecting%20is%20confidential.%3C%2FP%3E%3CP%3EAny%20help%20of%20suggestions%20are%20very%20welcome.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1938796%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938978%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20%22marry%22%20form%20responses%20with%20a%20specific%20person%20listed%20in%20another%20table%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938978%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F884882%22%20target%3D%22_blank%22%3E%40MagdaS%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20definitely%20are%20ways%20to%20do%20this.%20Without%20knowing%20the%20exact%20layout%20of%20the%20Google%20and%20Excel%20sheets%20you're%20working%20with%2C%20however%2C%20one%20can%20only%20give%20general%20suggestions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETake%20a%20look%20at%20VLOOKUP%2C%26nbsp%3B%20or%20XLOOKUP%20for%20starters.%20Here's%20a%20helpful%20site%20if%20you%20need%20assistance%20in%20the%20syntax%3A%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-xlookup-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-xlookup-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20basically%20mandatory%20for%20this%20kind%20of%20%22marrying%22%20or%20matching%20of%20data%20sets%20to%20have%20one%20field%20in%20each%20data%20set%20that%20is%20a%20reliable%20identifier.%20In%20your%20case%2C%20a%20student%20ID%20would%20be%20the%20ideal.%20Names%20are%20a%20poor%20second%2C%20for%20a%20variety%20of%20reasons%2C%20but%20they%20might%20be%20able%20to%20work%20if%20there's%20no%20ID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20not%20be%20able%20to%20post%20the%20actual%20data%20(for%20good%20reasons)%20but%20if%20you%20want%20further%20help%2C%20could%20I%20suggest%20making%20changing%20names%20to%20those%20of%20Disney%20characters%20and%20posting%20a%20semblance%20of%20your%20actual%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Please help me find a solution to my dilemma.  I have an excel table with hundreds of students, from whom I need to collect a lot of updated information. The form was set up in google forms and the replies are saved in google sheets.  The time matching an copying and updating manually each applicable field with about 40 different columns from google sheet to excel table is horrendous.  Is there a way to "marry" the information from the google sheet to the correct person on the excel table?

I can not attach a sample because the information I am collecting is confidential.

Any help of suggestions are very welcome.

Thank you.

 

1 Reply

@MagdaS 

There definitely are ways to do this. Without knowing the exact layout of the Google and Excel sheets you're working with, however, one can only give general suggestions.

 

Take a look at VLOOKUP,  or XLOOKUP for starters. Here's a helpful site if you need assistance in the syntax:  https://exceljet.net/excel-functions/excel-vlookup-function

https://exceljet.net/excel-functions/excel-xlookup-function

 

It is basically mandatory for this kind of "marrying" or matching of data sets to have one field in each data set that is a reliable identifier. In your case, a student ID would be the ideal. Names are a poor second, for a variety of reasons, but they might be able to work if there's no ID.

 

You may not be able to post the actual data (for good reasons) but if you want further help, could I suggest making changing names to those of Disney characters and posting a semblance of your actual data.