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

Copper Contributor

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