Fill rows in one sheet depending on what is written on a certain cell based on info in another sheet

Occasional Visitor

Hi there,


I'm struggling to make a sheet work as I intend. I have various sheets in a file where the first one is like a database of quite a few components and the other sheets are groups of components that create a product we sell. See example attached.


The thing I want to do is if I fill a cell in the product sheet, in this case would be "internal description", the other cells are filled automatically. That way, I think, if I change something in the database it will be automatically changed in the product sheet (price, ref,...), right?


I hope I'm being clear enough.


Thanks in advance!

0 Replies