If cell contains number -> show right additonal info text

[IM-Johnny]

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 Number	In-house number	Group Name	Product Descr1
111-001363	RDSPEAKER	Speaker G1	SPEAKER RED
111-001362	BLSPEAKER	Speaker G1	SPEAKER BLUE
111-001361	GRSPEAKER	Speaker G1	SPEAKER GREEN

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

Thanks in advance! :)

[#2]

@IM-Johnny 

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

[#3]

@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 :)

[#4]

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