Sep 11 2019 02:37 AM
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! :)
Sep 11 2019 02:42 AM
Sep 11 2019 04:19 AM
@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 :)
Sep 11 2019 04:51 AM
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.