SOLVED

Auto fill formula

Occasional Contributor

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.

9 Replies
Unfortunately, it's not that self-explanatory.
I who know nothing can not understand.

Auto fill formula from the columns of sheet 2 to the rows of sheet 1
from which columns? from sheet two
Should these be added up?
Anyway, I'm confused ... please explain in as much detail as possible, based on your inserted file.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)

@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.

best response confirmed by Oliullah (Occasional Contributor)
Solution

@Oliullah 

Formula here

image.png

could be

=INDEX(Sheet2!$3:$3, (ROW()-ROW($B$1))*3)

@Riny_van_Eekelen , missed your post, actually the same

@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.

Thanks. I should have been more explanatory.

I must keep in mind your valuable suggestions.

Thank you for your patience.
Thanks. Your table is correct.

Actually, I am searching auto fill formula Vertically from Horizontal reference.

Thank you for your valuable time.

@Oliullah 

Please check in column AF

=INDEX(TRANSPOSE('Sheet 2'!$K$63:$FP$63),(ROW()-ROW($D$12))*3)

 

Thanks.

Trying the formula.