Referencing rows to return value in column

[isalmon]

Afternoon All,

I am looking for help and guidance in solving my latest problem...

On the attached sheet i am looking to pull the sold units from column E to K on the order tab and put them into the corresponding row on the Masterworksheet tab.
Basically taking a user friendly format for our customers and placing it into the format needed to upload into our system...

Thanks in advance

[mehmetcik]

Paste this formula in Cell F2 on The Master Sheet

Then Fill down

=IF(ROW()<68,INDEX(ORDER!$F$20:$K$30,INT((ROW()-2)/6)+1,MOD(ROW()-2,6)+1),INDEX(ORDER!$E$34:$K$37,INT((ROW()-68)/7)+1,MOD(ROW()-68,7)+1))

[FDibbins]

Another options....
For the QTY based on Tops...
F2=INDEX(ORDER!$E$20:$K$37,MATCH(MasterWorksheet!$B2&" "&MasterWorksheet!$D2,INDEX(ORDER!$B$20:$B$37&" "&ORDER!$D$20:$D$37,0),0),MATCH($E2,IF(ISTEXT($E2),ORDER!$E$19:$K$19,ORDER!$E$33:$K$33),0))
copied down

BUT...
you need to change the "numbers" in E68:E95 to real numbers - they are currently TEXT - you can see that the are left-aligned (real numbers , by default, are right aligned) and they have that small green triangle in the top left corner.

For the unit price...
G2=INDEX(ORDER!$M$20:$M$37,MATCH(MasterWorksheet!$B2&" "&MasterWorksheet!$D2,INDEX(ORDER!$B$20:$B$37&" "&ORDER!$D$20:$D$37,0),0),)
copied down

[isalmon]

Thank you for the replies.

Mehmetcik's suggestion worked perfectly.

Cheers
Ian