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.
- OliullahMar 05, 2021Copper ContributorThanks. Your table is correct.
Actually, I am searching auto fill formula Vertically from Horizontal reference.
Thank you for your valuable time. - SergeiBaklanMar 04, 2021Diamond Contributor
Riny_van_Eekelen , missed your post, actually the same