Forum Discussion
Oliullah
Mar 04, 2021Copper Contributor
Auto fill formula
Hello, The attached file is self explanatory. I badly need a formula in Column C of sheet 1. Auto fill Formula from the columns of sheet 2 to the rows of sheet 1 Please help me. Than...
- Mar 04, 2021
Riny_van_Eekelen
Mar 04, 2021Platinum Contributor
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.
Oliullah
Mar 05, 2021Copper Contributor
Thanks. Your table is correct.
Actually, I am searching auto fill formula Vertically from Horizontal reference.
Thank you for your valuable time.
Actually, I am searching auto fill formula Vertically from Horizontal reference.
Thank you for your valuable time.