Multiple level data validation across worksheet with common name for final level

SamHorlick

New Member
Joined
Mar 8, 2017
Messages
3
Hi everyone, this is my first post. I am trying to set up a 3 level drop down list using data validation with the 'INDIRECT' function. The problem arises because the second level requires data groups with the same name.

I am trying to identify where we have the most problems in a chemical plant. Each level is a more specific location- the final level being the exact equipment.
  • Level 1- area
  • Level 2- type of equipment
  • Level 3- equipment number
All areas are different but also have the same types of equipment though- pumps, valves, etc. When I try to save a new data set as valve, excel will tell me I already used this name for a different area. I have tried naming sets of data to only their respective sheet to solve this problem, but then the main sheet where the actual drop down list is doesn't recognize the names.

For clarity I will just show what I am trying to accomplish.
(let me know if this link doesn't work). Notice how level one ends up at the same name for level 2 multiple times. (a-1, b-1)

I know this is tough to explain, so if you have questions, please ask.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

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