Report a cell to another sheet with a condition
Solved
Kambro
Posted messages
55
Status
Membre
-
Kambro Posted messages 55 Status Membre -
Kambro Posted messages 55 Status Membre -
Hello,
In the file provided:
https://www.dropbox.com/s/81ffj157c5...%202.xlsx?dl=0
1. I fill in the cells of column C of the "products" sheet using the dropdown list referring to the items in column C of the "categories" sheet.
2. I would like the cells in column B (still in the "products" sheet) to be automatically filled with the content from column B of the "categories" sheet located on the same row as the item selected in point 1 above.
3. If this "source" cell B is empty, it must retrieve the content from the nearest non-empty cell above.
4. The same applies to column A of the "products" sheet.
Example: in the "products" sheet I checked "Official liturgical books" (cell C68). B68 should be filled with "Liturgical books" and A68 with "Liturgy".
Thank you in advance,
Kambro
Configuration: Mac OS X (10.9.5) / Safari 9.1.1
In the file provided:
https://www.dropbox.com/s/81ffj157c5...%202.xlsx?dl=0
1. I fill in the cells of column C of the "products" sheet using the dropdown list referring to the items in column C of the "categories" sheet.
2. I would like the cells in column B (still in the "products" sheet) to be automatically filled with the content from column B of the "categories" sheet located on the same row as the item selected in point 1 above.
3. If this "source" cell B is empty, it must retrieve the content from the nearest non-empty cell above.
4. The same applies to column A of the "products" sheet.
Example: in the "products" sheet I checked "Official liturgical books" (cell C68). B68 should be filled with "Liturgical books" and A68 with "Liturgy".
Thank you in advance,
Kambro
Configuration: Mac OS X (10.9.5) / Safari 9.1.1
