K
Karolus
Hi,
I'm wonder if there is a way to use native (prebuild) function t
achieve the following:
- In sheet 2 I have a list of products in column A and price of produc
in column B
- In sheet 1 I want to select product with it's price
Currently working fine with vlookup function.
What I would like to add, is functionality that some products ar
related to each other means if I will select Product i.e. potato o
sheet 1 from the list in sheet 2, I will create a special column C i
sheet 2 with entry i.e. water which will determine my trigger that wil
add this product (water) automatically above my selected produc
(potato) and my product will be shifted down or up one row in sheet 1
Any idea?
regards
Karo
I'm wonder if there is a way to use native (prebuild) function t
achieve the following:
- In sheet 2 I have a list of products in column A and price of produc
in column B
- In sheet 1 I want to select product with it's price
Currently working fine with vlookup function.
What I would like to add, is functionality that some products ar
related to each other means if I will select Product i.e. potato o
sheet 1 from the list in sheet 2, I will create a special column C i
sheet 2 with entry i.e. water which will determine my trigger that wil
add this product (water) automatically above my selected produc
(potato) and my product will be shifted down or up one row in sheet 1
Any idea?
regards
Karo