Home

Faster way to do this!

%3CLINGO-SUB%20id%3D%22lingo-sub-854823%22%20slang%3D%22en-US%22%3EFaster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20of%20reoccurring%20data%20that%20has%20the%20same%20letters%20through%20out%20the%20columns%20in%20different%20orders%2C%20and%20I%20need%20to%20insert%20names%20to%20those%20reoccurring%20sets%20of%20data.%20My%20question%20is%2C%20is%20there%20a%20faster%20way%20to%20put%20in%20those%20names%20instead%20of%20doing%20it%20manually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-854823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857131%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857131%22%20slang%3D%22en-US%22%3ECan%20you%20post%20a%20sample%20workbook%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065590%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065590%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20the%20late%20reply%20about%20this.%20Those%20letters%20to%20the%20left%20(THO%2C%20SHH%2C%20etc)%20I%20have%2C%20but%20how%20do%20I%20add%20the%20ones%20to%20the%20right%20much%20easier(West%2C%20Loan%2C%20Super%2C%20etc)%3F%26nbsp%3B%20Instead%20of%20having%20to%20manually%20add%20those%20in%20there%20one%20by%20one%20and%20dragging%20them%20down.%20I%20have%20over%201000%20rows%20of%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065593%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065593%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065597%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065597%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161727iF0DF26B648701BFD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22ExcelForum.JPG%22%20title%3D%22ExcelForum.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065777%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065777%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20like%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161757iF2941A89966908CE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065830%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065830%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20exactly%20like%20that.%20BUT%20I%20have%20over%20170%20different%20names%20in%20that%20A%20Column%2C%20and%20over%201000%20rows%20that%20need%20to%20be%20filled.%20That%20was%20a%20short%20example%20of%20what%20I%20am%20trying%20to%20do.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20about%2025%20Names%20and%20those%20names%20go%20to%20a%20specific%203%20letter%20code%20(there%20are%20about%20170%20different%203%20letter%20codes)%20%2C%20and%20I%20have%20about%201000%20of%20those%203%20letter%20codes%20those%20names%20belong%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20I%20have%20to%20have%20a%20really%20long%20formula%20to%20execute%20this%3F%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F487135%22%20target%3D%22_blank%22%3E%40Fortijo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065885%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065885%22%20slang%3D%22en-US%22%3EHave%20a%20look%20at%20the%20vlookup%20function.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065939%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065939%22%20slang%3D%22en-US%22%3EYou%20would%20need%2025%20names%20in%20this%20instance.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1067852%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1067852%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%20Can%20you%20please%20upload%20a%20(sanitized)%20copy%20of%20your%20file%20with%20just%20the%20long%20list%20of%20codes%20and%20the%20list%20of%2025%20names%20and%20their%20codes%3F%20I'm%20sure%20this%20requires%20a%20simple%20VLOOKUP%20rather%20than%20the%20complicated%2025-level%20nested%20IF%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1068278%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1068278%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20way%20is%2C%20insert%20a%20sheet%20called%20%22List%22%20with%20all%20the%20possible%20three%20letters%20string%20in%20column%20A%20and%20their%20corresponding%20names%20in%20column%20B%20as%20shown%20in%20the%20attached.%20Please%20refer%20to%20the%20List%20Sheet.%3C%2FP%3E%3CP%3EThen%20place%20the%20following%20code%20on%20a%20Standard%20Module%20like%20Module1%20so%20that%20the%20code%20will%20loop%20through%20all%20the%20three%20letters%20strings%20in%20column%20A%20on%20Data%20Sheet%20and%20place%20their%20corresponding%20names%20in%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3ECode%20on%20Module1%3A%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3ESub%20FillNames()%0ADim%20wsData%20%20%20%20%20%20As%20Worksheet%0ADim%20wsList%20%20%20%20%20%20As%20Worksheet%0ADim%20LastRow%20%20%20%20%20As%20Long%0ADim%20rng%20%20%20%20%20%20%20%20%20As%20Range%0ADim%20cel%20%20%20%20%20%20%20%20%20As%20Range%0ADim%20str%20%20%20%20%20%20%20%20%20As%20String%0ADim%20rngStr%20%20%20%20%20%20As%20Range%0A%0ASet%20wsData%20%3D%20Worksheets(%22Data%22)%20%20%20%20%20'Sheet%20with%20data.%0ASet%20wsList%20%3D%20Worksheets(%22List%22)%20%20%20%20%20'Sheet%20with%20list%20of%20strings%20and%20their%20respective%20names%0A%0ALastRow%20%3D%20wsData.Cells(Rows.Count%2C%20%22A%22).End(xlUp).Row%0AIf%20LastRow%20%3D%201%20Then%0A%20%20%20%20MsgBox%20%22There%20is%20no%20data%20on%20the%20Sheet.%22%2C%20vbExclamation%0A%20%20%20%20Exit%20Sub%0AEnd%20If%0A%0ASet%20rng%20%3D%20wsData.Range(%22A2%3AA%22%20%26amp%3B%20LastRow)%0A%0AFor%20Each%20cel%20In%20rng%0A%20%20%20%20If%20cel%20%26lt%3B%26gt%3B%20%22%22%20Then%0A%20%20%20%20%20%20%20%20Set%20rngStr%20%3D%20wsList.Range(%22A%3AA%22).Find(what%3A%3Dcel.Value%2C%20lookat%3A%3DxlWhole%2C%20MatchCase%3A%3DFalse)%0A%20%20%20%20%20%20%20%20If%20Not%20rngStr%20Is%20Nothing%20Then%0A%20%20%20%20%20%20%20%20%20%20%20%20cel.Offset(0%2C%201).Value%20%3D%20rngStr.Offset(0%2C%201).Value%0A%20%20%20%20%20%20%20%20End%20If%0A%20%20%20%20Else%0A%20%20%20%20%20%20%20%20cel.Offset(0%2C%201).Value%20%3D%20%22%22%0A%20%20%20%20End%20If%0ANext%20cel%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20click%20the%20button%20called%20%22Fill%20Names%22%20on%20Data%20Sheet%20to%20run%20the%20code.%3C%2FP%3E%3CP%3EWhile%20implementing%20this%20code%20to%20your%20original%20file%2C%20make%20sure%20that%20you%20tweak%20the%20sheet%20names%20in%20the%20code%20before%20executing%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072172%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072172%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20just%20a%20shorten%20down%20example.%20I%20tried%20to%20look%20up%20videos%20on%20Vlookup%20but%20no%20luck.%20If%20you%20can%20show%20me%20how%20that%20is%20done%20that%20will%20be%20great.%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20you%20need%20more%20information.%20.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072243%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072243%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%20I'm%20sorry%2C%20but%20I%20have%20no%20idea%20what%20it%20is%20you%20are%20trying%20to%20achieve%20with%20this%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072401%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072401%22%20slang%3D%22en-US%22%3E%3CP%3EMay%20be%20you%20can%20try%20find%20and%20replace%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072412%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072412%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20is%20Okay!%20I%20am%20sorry%2C%20I've%20probably%20been%20explain%20it%20harder%20that%20it%20really%20is.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20attachment%20I%20sent%2C%20this%20is%20what%20it%20should%20looks%20like%20when%20I%20am%20working%20on%20it.%20What%20I%20am%20trying%20to%20do%20is%20to%20put%20the%20names%20that%20belong%20to%20that%203%20letter%20code%20(Column%20A)%2C%20but%20find%20the%20easiest%20possible%20way%20to%20do%20that%20instead%20of%20doing%20it%20all%20manually.%20I%20have%20a%20list%20so%20I%20know%20where%20the%20names%20belong%20to%20in%20that%203%20letter%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20still%20confused%20that%20is%20okay%2C%20thanks!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072432%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072432%22%20slang%3D%22en-US%22%3Eyou%20can%20also%20use%20flash%20fill%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072447%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072447%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tried%20that%2C%20but%20when%20it%20auto%20fills%20it%20does%20it%20incorrectly.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F492895%22%20target%3D%22_blank%22%3E%40Saty_Rana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072461%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072461%22%20slang%3D%22en-US%22%3Ei%20did%20it...i%20think%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072470%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072470%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20just%20a%20small%20example...%20when%20I%20do%20it%20when%20i%20am%20in%20the%20middle%20of%20finishing%20it%20use%20auto%20fill%20and%20when%20i%20look%20its%20mostly%20all%20incorrect...%20Ill%20give%20it%20a%20try%20and%20see%20what%20happens%20with%20this%20small%20example.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F492895%22%20target%3D%22_blank%22%3E%40Saty_Rana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072471%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072471%22%20slang%3D%22en-US%22%3E%3CP%3Emove%20the%20data%20from%20row%20D%20to%20row%20F%2C%20Now%20use%20formula%20%3DVLOOKUP(B2%2CE%242%3AF%2455%2C2%2CFALSE)%20in%20A2%2C%20Drag%20it%20till%20last%20cell%2C%20it%20would%20fill%20al%20the%20cells%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072477%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072477%22%20slang%3D%22en-US%22%3E%3CP%3EHuh...%20when%20I%20type%20in%20the%20formula%20I%20got%20an%20error...%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F492895%22%20target%3D%22_blank%22%3E%40Saty_Rana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072486%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072486%22%20slang%3D%22en-US%22%3Esee%20my%20sheet%2C%20tell%20if%20you%20exactly%20wanted%20same%20or%20something%20else%3F%3F%3F%3F%3CBR%20%2F%3Eyou%20need%20to%20move%20data%20from%20row%20D%20to%20row%20F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072532%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072532%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20exactly%20what%20I%20am%20looking%20for!%20but%20I%20still%20seem%20to%20get%20an%20error%20when%20i%20moved%20row%20D%20to%20Row%20F%20and%20when%20I%20made%20move%20it%20to%20look%20exactly%20like%20yours.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F492895%22%20target%3D%22_blank%22%3E%40Saty_Rana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072536%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072536%22%20slang%3D%22en-US%22%3Ehave%20you%20placed%20%24%20sign%20correctly%3F%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072540%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072540%22%20slang%3D%22en-US%22%3Ethe%20data%20you%20have%20placed%20is%20wrong.%20you%20need%20to%20interchange%20data%20in%20row%20E%20and%20F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072545%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072545%22%20slang%3D%22en-US%22%3Eyou%20need%20to%20clear%20your%20concept%20a%20little%20on%20vlookup%2C%20try%20watching%20a%20tutorial%20on%20youtube.%20its%20an%20easy%20topic%20and%20would%20help%20you%20alot%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072555%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072555%22%20slang%3D%22en-US%22%3E%3CP%3EOh%20my%20gosh%20it%20worked!!%20lol%20So%20this%20is%20just%20a%20small%20example%20of%20what%20I%20really%20do%20but%20i%20will%20apply%20it%20to%20my%20actual%20sheet.%20Anyway%20you%20can%20tell%20me%20what%20everything%20in%20that%20formula%20means%3F%20Such%20as%26nbsp%3B%20the%20%24%2C%20the%202%2C%20and%20the%20FALSE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F492895%22%20target%3D%22_blank%22%3E%40Saty_Rana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072557%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072557%22%20slang%3D%22en-US%22%3EIndian%20Jugaad....%20am%20really%20happy%20it%20worked%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072562%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072562%22%20slang%3D%22en-US%22%3E%3DVLOOKUP(B2%2CE%242%3AF%2455%2C2%2CFALSE)%3CBR%20%2F%3E%3CBR%20%2F%3Ehere%20dollar%20signs%20are%20placeed%20so%20that%20cell%20id%20dont%20change%20i.e.%20E2%3AF55%20to%20B3%3AF56%20when%20you%20drag%20it%20down%20and%20so%20on%2C%20like%20flashfill%3CBR%20%2F%3E%3CBR%20%2F%3E2%20here%20is%20the%20row%20number%20from%20where%20to%20pick%20up%20data%3CBR%20%2F%3E%3CBR%20%2F%3Efalse%20here%20means%20exact%20match%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3Esee%20tutorial%20on%20vlookup%20for%20more%20info%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072563%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072563%22%20slang%3D%22en-US%22%3Echeears!!!!!!!!!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072575%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408643%22%20target%3D%22_blank%22%3E%40jrramz22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20worth%20to%20spend%20few%20minutes%20and%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fswitch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESwitch%20between%20relative%2C%20absolute%2C%20and%20mixed%20references%3C%2FA%3E%26nbsp%3B%20and%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EVLOOKUP%20function%3C%2FA%3E%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072579%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072579%22%20slang%3D%22en-US%22%3Eare%20you%20a%20bot%3F%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072580%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072580%22%20slang%3D%22en-US%22%3Eits%20a%20compliment%2C%20coz%20you%20know%20links%20to%20everything....%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072657%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072657%22%20slang%3D%22en-US%22%3ENo%2C%20Sergei%20is%20a%20real%20person%2C%20we've%20met%20some%20years%20ago.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072674%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072674%22%20slang%3D%22en-US%22%3Ehe%20is%20really%20amazing%20person...regards%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072705%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072705%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%20for%20you%20help!%20Ill%20look%20more%20into%20vlookup!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F492895%22%20target%3D%22_blank%22%3E%40Saty_Rana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072709%22%20slang%3D%22en-US%22%3ERe%3A%20Faster%20way%20to%20do%20this!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072709%22%20slang%3D%22en-US%22%3E(y)%20greetings%3C%2FLINGO-BODY%3E
jrramz22
Occasional Contributor

I have a set of reoccurring data that has the same letters through out the columns in different orders, and I need to insert names to those reoccurring sets of data. My question is, is there a faster way to put in those names instead of doing it manually.

 

34 Replies
Can you post a sample workbook please?

@Jan Karel Pieterse 

Sorry for the late reply about this. Those letters to the left (THO, SHH, etc) I have, but how do I add the ones to the right much easier(West, Loan, Super, etc)?  Instead of having to manually add those in there one by one and dragging them down. I have over 1000 rows of this. 

ExcelForum.JPG

@jrramz22 

Hi @jrramz22 

Something like this?

clipboard_image_0.png

Yes, exactly like that. BUT I have over 170 different names in that A Column, and over 1000 rows that need to be filled. That was a short example of what I am trying to do. 

 

I have about 25 Names and those names go to a specific 3 letter code (there are about 170 different 3 letter codes) , and I have about 1000 of those 3 letter codes those names belong to.

 

Would I have to have a really long formula to execute this?  @Fortijo 

Have a look at the vlookup function.
You would need 25 names in this instance.

@jrramz22 Can you please upload a (sanitized) copy of your file with just the long list of codes and the list of 25 names and their codes? I'm sure this requires a simple VLOOKUP rather than the complicated 25-level nested IF formula.

This is just a shorten down example. I tried to look up videos on Vlookup but no luck. If you can show me how that is done that will be great.

Let me know if you need more information. . @Jan Karel Pieterse 

@jrramz22 I'm sorry, but I have no idea what it is you are trying to achieve with this list.

May be you can try find and replace@jrramz22 

That is Okay! I am sorry, I've probably been explain it harder that it really is. 

 

On the attachment I sent, this is what it should looks like when I am working on it. What I am trying to do is to put the names that belong to that 3 letter code (Column A), but find the easiest possible way to do that instead of doing it all manually. I have a list so I know where the names belong to in that 3 letter code.

 

If you are still confused that is okay, thanks! @Jan Karel Pieterse 

you can also use flash fill

I tried that, but when it auto fills it does it incorrectly. @Saty_Rana 

i did it...i think

This is just a small example... when I do it when i am in the middle of finishing it use auto fill and when i look its mostly all incorrect... Ill give it a try and see what happens with this small example.@Saty_Rana 

move the data from row D to row F, Now use formula =VLOOKUP(B2,E$2:F$55,2,FALSE) in A2, Drag it till last cell, it would fill al the cells@jrramz22 

Huh... when I type in the formula I got an error...@Saty_Rana 

see my sheet, tell if you exactly wanted same or something else????
you need to move data from row D to row F

This is exactly what I am looking for! but I still seem to get an error when i moved row D to Row F and when I made move it to look exactly like yours. @Saty_Rana 

have you placed $ sign correctly??
the data you have placed is wrong. you need to interchange data in row E and F
you need to clear your concept a little on vlookup, try watching a tutorial on youtube. its an easy topic and would help you alot

Oh my gosh it worked!! lol So this is just a small example of what I really do but i will apply it to my actual sheet. Anyway you can tell me what everything in that formula means? Such as  the $, the 2, and the FALSE.

 

Thank you! @Saty_Rana 

Indian Jugaad.... am really happy it worked
=VLOOKUP(B2,E$2:F$55,2,FALSE)

here dollar signs are placeed so that cell id dont change i.e. E2:F55 to B3:F56 when you drag it down and so on, like flashfill

2 here is the row number from where to pick up data

false here means exact match



see tutorial on vlookup for more info
cheears!!!!!!!!!!

@jrramz22 

It's worth to spend few minutes and check Switch between relative, absolute, and mixed references  and VLOOKUP function   

are you a bot???
its a compliment, coz you know links to everything....
No, Sergei is a real person, we've met some years ago.
he is really amazing person...regards

Thank you so much for you help! Ill look more into vlookup!@Saty_Rana 

(y) greetings
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies