Mar 04 2021 09:53 AM
Mar 04 2021 12:06 PM
Mar 04 2021 01:33 PM
@Oliullah Offering you a formula that does what you ask for. Though I'm not convinced that this what you really need. am assuming that Product A = 10kg, Product B = 15kg etc.
Perhaps you want to reconsider the structure of the data in sheet 2, as proposed in the green shaded area. See attached.
Mar 04 2021 05:59 PM
@Sergei Baklan Thanks a lot.
Please help me with the attached file.
In sheet 1, Column D, I have manually linked the cell reference from Sheet 2.
And in Sheet 1 , Cell E13, Cell F13, Cell G13, Cell H13, Cell I13 I have manually linked the cell reference from Sheet 2.
Now, I need your magical formula in Sheet 1 (Column D, Column E, Column F, Column G, Column H, Column I)
Mar 04 2021 06:08 PM