Super challenge for the beginning of the year

Audiman

New Member
Joined
Sep 10, 2009
Messages
31
This is far beyond my scope and I have over 2700 entries that I need to do this for and really hoping someone here can help me with this.

Table 1 - Resides in A9:Z2780
ABCDEFGHI
JACKETSJACKETS1043-11001PORT JACKETGREEN60EA


<tbody>
</tbody>

The above table I need Cell A To contain D+H+ some sort of vlookup of CELL I from the table 2 below. Example
Cell A in the sample above would make 5 new lines.. And cell E. Because CELL I in this example = "A" we use S, M, L, XL, XXL
CELL A CELL E
1043-110160ES PORT JACKET GREEN SMALL
1043-110160EM PORT JACKET GREEN MEDIUM
1043-110160EL PORT JACKET GREEN LARGE
1043-110160EXL PORT JACKET GREEN XLARGE
1043-110160EXXL PORT JACKET GREEN XXLARGE

And still copy all the data from the others cells From A to Z

Table 2 - J4:T7
A S M L XL XXL
B 28 29 30 31 32 33 34 36 38 40
C O/S S/M L/XL
D 7 8 9 10 11 12 13

<tbody>
</tbody><colgroup><col><col span="10"></colgroup>
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top