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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies