Control Box and Index

Henry

Board Regular
Joined
Mar 7, 2002
Messages
180
Hi: Let me see if i can explain this w/ot cause mass confusion. I am using Control Box, the one with drop down selection capability. I have a in A1 thru A10, meaning 10 boxes. The data that comprises the box is in a 2nd worksheet titled data. Each DD allows the customer to select from 150 different names. Each box has 150 names to choose from. So, once the customer selects 10 names, which in turn are placed in each respective cell using Index (same data worksheet), I then used Concatenate and pull all 10 names into one large cell. So A1 thru A10, using Control Box is tied to Index which in turns places the chose name in cells A1-A1-. Then I Concatenate A1-A10 into B1. Does this make sense. The real problem, besides mass inefficiencies, is I have to have 10 cocmplete sets of names (10 x 150) just to get the info into B1. Isn't there a cheaper, better, faster way of getting this done. My current method means lots and lots of data on my Data WS. Thanks Again.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,159
Messages
5,768,520
Members
425,479
Latest member
Neerajcool

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
Top