Home

If cell contains number -> show right additonal info text

%3CLINGO-SUB%20id%3D%22lingo-sub-848301%22%20slang%3D%22en-US%22%3EIf%20cell%20contains%20number%20-%26gt%3B%20show%20right%20additonal%20info%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848301%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20working%20on%20a%20work%20file%2C%20where%20i%20have%20a%20lot%20of%20article%20numbers.%20And%20I%20want%20to%20write%20the%20article%20number%20in%20C8%20for%20example%2C%20and%20want%20the%20right%20additional%20info%20to%20be%20displayed%20in%20D8%2C%20E8%20and%20F8.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E(Black%20text%20is%20want%20i%20write%20in.%20Green%20text%20appear%20automatic)%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CSTRONG%3EArticle%20Number%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3EIn-house%20number%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3EGroup%20Name%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3EProduct%20Descr1%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3E111-001363%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3ERDSPEAKER%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3ESpeaker%20G1%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3ESPEAKER%20RED%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3E111-001362%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3EBLSPEAKER%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3ESpeaker%20G1%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3ESPEAKER%20BLUE%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3E111-001361%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3EGRSPEAKER%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3ESpeaker%20G1%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%2300FF00%22%3E%3CEM%3ESPEAKER%20GREEN%3C%2FEM%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20completely%20new%20in%20Excel%2C%20but%20this%20would%20save%20me%20a%20lot%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-848301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848306%22%20slang%3D%22en-US%22%3ERe%3A%20If%20cell%20contains%20number%20-%26gt%3B%20show%20right%20additonal%20info%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848306%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F407103%22%20target%3D%22_blank%22%3E%40IM-Johnny%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20is%20the%20formal%20logic%20behind%2C%20how%20Excel%20knows%20what%20exactly%20to%20put%20in%20next%20columns%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848412%22%20slang%3D%22en-US%22%3ERe%3A%20If%20cell%20contains%20number%20-%26gt%3B%20show%20right%20additonal%20info%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848412%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI'll%20will%20have%20a%20sheet%20with%20all%20the%20nessecary%20info.%20So%20if%20there%20is%20a%20way%20to%20autofill%20the%20rest%20of%20the%20columms%20on%20another%20sheet%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848472%22%20slang%3D%22en-US%22%3ERe%3A%20If%20cell%20contains%20number%20-%26gt%3B%20show%20right%20additonal%20info%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F407103%22%20target%3D%22_blank%22%3E%40IM-Johnny%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20Article%20Numbers%20are%20unique%20you%20may%20use%20INDEX%2FMATCH%20or%20VLOOKUP%20on%20the%20sheet%20with%20information%20to%20return%20necessary%20data.%20If%20you%20provide%20sample%20file%20we%20may%20play%20with%20concrete%20formulas.%3C%2FP%3E%3C%2FLINGO-BODY%3E
IM-Johnny
New Contributor

I'm working on a work file, where i have a lot of article numbers. And I want to write the article number in C8 for example, and want the right additional info to be displayed in D8, E8 and F8.

 

Example:

(Black text is want i write in. Green text appear automatic)

Article NumberIn-house numberGroup NameProduct Descr1
111-001363RDSPEAKERSpeaker G1SPEAKER RED
111-001362BLSPEAKERSpeaker G1SPEAKER BLUE
111-001361GRSPEAKERSpeaker G1SPEAKER GREEN

 

I'm completely new in Excel, but this would save me a lot of time.

 

Thanks in advance!

3 Replies

@IM-Johnny 

 

What is the formal logic behind, how Excel knows what exactly to put in next columns?

@Sergei Baklan I'll will have a sheet with all the nessecary info. So if there is a way to autofill the rest of the columms on another sheet

@IM-Johnny 

If your Article Numbers are unique you may use INDEX/MATCH or VLOOKUP on the sheet with information to return necessary data. If you provide sample file we may play with concrete formulas.