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
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