Multiple Lists Using INDIRECT Help?

abutler1986

New Member
Joined
Mar 11, 2015
Messages
34
Hi All,

I have a simple List at the moment but need to expand it, struggling to link two lists together as I have not experimented which this before.

My raw data currently looks like this:
ManufacturerModel
RicohMPC3000
RicohMPC2000
RicohMPC1000
KMTA3200
KMTA2100
LexmarkC77X
LexmarkC67X

<tbody>
</tbody>


Basically I need to be able to have a list that first selects then Manufacturer, then in the column next to it I need it to select the Model..

So if I pick Ricoh I should only see three models in the next List.

Hope this makes sense.

Thanks

Andrew
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
ManufacturerModel
RicohMPC3000
RicohMPC2000
RicohMPC1000
KMTA3200
KMTA2100
LexmarkC77X
LexmarkC67X
ManufacturerRicoh
Count of Model
ModelTotal
MPC10001
MPC20001
MPC30001
Grand Total3
a pivot table will list and count all models for a selected manufacturer

<colgroup><col><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>
 
Upvote 0
Hello Oldbrewer,

Thanks for this but this is not exactly what I am looking for.

What I have created at the moment is a kind of form within Excel, currently I have bundled all models in one long list from a drop down then I have VLOOKUPS based on whatever model is selected however what I now need is another drop down created.

So the user now has to select a manufacturer first (example Ricoh), once they have picked Ricoh from the first drop down list you can only select the models associated with Ricoh in the second drop down list.

Not sure this is possible?
 
Upvote 0
try create the name range :

name - Ricoh
Refers to:
MPC3000,MPC2000,MPC1000

=indirect(first cell with name)

 
Upvote 0
Yeah I literally just tried this and it worked how I needed it to thanks for this.

Sub question though, is there anyway I can "reset" the second drop list if I pick a different option from the first drop down list?
 
Upvote 0
RicohMPC3000RicohRicohKMLexmark
RicohMPC2000KMMPC3000TA3200TA3200
RicohMPC1000LexmarkMPC2000TA2100TA2100
KMTA3200MPC1000
KMTA2100
LexmarkC77X
LexmarkC67X
D15
RicohMPC3000
MPC2000
MPC1000
0
0
0
0
0
0
0
D15 is your first drop down
the list to the right is auto populated
depending on the selection in the dropdown

<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>
</tbody>
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

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