# Super challenge for the beginning of the year

#### Audiman

##### New Member
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
 A B C D E F G H I JACKETS JACKETS 1043-11001 PORT JACKET GREEN 60E A

<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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### BIGTONE559

##### Active Member
do you have a sample of the actual spreadsheet?

Sent a pm

Last edited:

Replies
4
Views
597
Replies
4
Views
236
Replies
3
Views
280
Replies
4
Views
691
Replies
1
Views
194

1,172,173
Messages
5,879,467
Members
433,435
Latest member
bryanrobson

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

### Which adblocker are you using?

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

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