Vlook up Formula Needed

%3CLINGO-SUB%20id%3D%22lingo-sub-1597669%22%20slang%3D%22en-US%22%3EVlook%20up%20Formula%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597669%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20a%20large%20quantity%20of%20data%20that%20I%20need%20to%20update%20daily%20from%20excel%20files.%20I%20start%20with%20lets%20say%20the%20data%20on%201-1-2020%20and%20I%20need%20to%20see%20if%20there%20were%20any%20changes%20on%201-2-2020%20and%20input%20the%20notes%20from%20the%201-1-2020%20file%20to%20the%20corresponding%20matching%20data%20on%201-2-2020.%20%22matching%22%20is%20not%20enough%20still%20leaves%20me%20with%20a%20ton%20of%20corrections%20that%20I%20do%20not%20have%20enough%20time%20to%20do.%20v%20or%20x%20look%20up%20would%20be%20the%20best%20formula%20where%20everyday%20I%20can%20put%20a%20new%20sheet%20and%20it%20will%20automatically%20add%20any%20matching%20notes%20from%20previous%20sheets.%20I%20want%20to%20find%20%26amp%3B%20match%20the%20information%20found%20in%20c2%20on%20sheet%201%20to%20c2%20sheet%202%20and%20input%20the%20notes%20in%20i2%20sheet%201%20onto%20sheet%202%20i2%2C%20if%20there%20are%20no%20notes%20leave%20blank%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1597669%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormula%20help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi Everyone 

i have a large quantity of data that I need to update daily from excel files. I start with lets say the data on 1-1-2020 and I need to see if there were any changes on 1-2-2020 and input the notes from the 1-1-2020 file to the corresponding matching data on 1-2-2020. "matching" is not enough still leaves me with a ton of corrections that I do not have enough time to do. v or x look up would be the best formula where everyday I can put a new sheet and it will automatically add any matching notes from previous sheets. I want to find & match the information found in c2 on sheet 1 to c2 sheet 2 and input the notes in i2 sheet 1 onto sheet 2 i2, if there are no notes leave blank 

 

 

 

 

 

0 Replies