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.
(Black text is want i write in. Green text appear automatic)
I'm completely new in Excel, but this would save me a lot of time.
Thanks in advance!
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
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.