Mar 04 2021 09:53 AM
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.
Thanks a lot.
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 01:41 PM
SolutionMar 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)
Thanks again.
Mar 04 2021 06:04 PM
Mar 04 2021 06:08 PM
Mar 05 2021 01:23 PM
Mar 04 2021 01:41 PM
SolutionFormula here
could be
=INDEX(Sheet2!$3:$3, (ROW()-ROW($B$1))*3)