Creating a list depending on the the result of another column

[danwaddy]

I've tried and tried to follow an online tutorial but for some reason its not working, it keeps saying that i need to add a ' at the beginning to make it work.

So here is what i'm trying to do, below is my list of information which i have on a hidden 'data' sheet. On my form creation sheet i want the information in the location column e.g. A2 to be a list and based on this selection i want another list to be available in the next cell eg B2. I do have another list of the 'Location' in the data sheet that doesn't duplicate the information (I assume this is needed?) any help would be greatly appreciated. each of these lists are in named tables.

Any help is really appreciated.
[TABLE="width: 322"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Location[/TD]
[TD]Equipment / Tag / ID[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]Centrifuge A[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]Centrifuge B[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]Havesting CIP[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]GMB40K[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]HV8000[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]Condenser[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]Vac System[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]Paste Line[/TD]
[/TR]
[TR]
[TD]Centrifuge Rm[/TD]
[TD]Hose Station[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]HPH A[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]HPH B[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]Transfer Panel[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]CDX 1000[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]Condenser[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]Vac System[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]Paste Line[/TD]
[/TR]
[TR]
[TD]Hot Paste Rm[/TD]
[TD]Hose Station[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]CPC A[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]CPC B[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]CPH A[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]CPH B[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]CP Pump A[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]CP Pump B[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]Paste Line[/TD]
[/TR]
[TR]
[TD]Cold Paste Area[/TD]
[TD]Hose Station North[/TD]
[/TR]
[TR]
[TD]Mixing Area[/TD]
[TD]Conti Mixer[/TD]
[/TR]
[TR]
[TD]Mixing Area[/TD]
[TD]Mixer Pump[/TD]
[/TR]
[TR]
[TD]Mixing Area[/TD]
[TD]Silverson Pump[/TD]
[/TR]
[TR]
[TD]Mixing Area[/TD]
[TD]Paste Line[/TD]
[/TR]
[TR]
[TD]Mixing Area[/TD]
[TD]Hose Station West[/TD]
[/TR]
[TR]
[TD]Dry Ingredients Rm[/TD]
[TD]Pre Mix 1 (South)[/TD]
[/TR]
[TR]
[TD]Dry Ingredients Rm[/TD]
[TD]Pre Mix 2 (Middle)[/TD]
[/TR]
[TR]
[TD]Dry Ingredients Rm[/TD]
[TD]Pre Mix 3 (North)[/TD]
[/TR]
[TR]
[TD]Forming Area[/TD]
[TD]Paste Line[/TD]
[/TR]
[TR]
[TD]Forming Area[/TD]
[TD]Forming Machine[/TD]
[/TR]
[TR]
[TD]Forming Area[/TD]
[TD]Cooker infeed Con[/TD]
[/TR]
[TR]
[TD]Cooker[/TD]
[TD]Cooker Belt[/TD]
[/TR]
[TR]
[TD]Cooker[/TD]
[TD]Drum Motor[/TD]
[/TR]
[TR]
[TD]Cooker[/TD]
[TD]Tention Motor[/TD]
[/TR]
[TR]
[TD]Transition Rm[/TD]
[TD]Trans Conveyor[/TD]
[/TR]
[TR]
[TD]Chiller[/TD]
[TD]Cooker Belt[/TD]
[/TR]
[TR]
[TD]Chiller[/TD]
[TD]Drum Motor[/TD]
[/TR]
[TR]
[TD]Chiller[/TD]
[TD]Tention Motor[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Chill Out Conveyor[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Dicer In Converyor[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Mincer In Conveyor[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Dicer[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Mincer[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Dicer Out Conveyor[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Long Conveyor[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Octofrost In Conveyor[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Vibros[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Frozen Prod Hopper[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Hose Station North[/TD]
[/TR]
[TR]
[TD]Mincing & Dicing Rm[/TD]
[TD]Hose Station East[/TD]
[/TR]
[TR]
[TD]Multi Head Weigher Rm[/TD]
[TD]Vibros[/TD]
[/TR]
[TR]
[TD]Multi Head Weigher Rm[/TD]
[TD]MHW Retail 1[/TD]
[/TR]
[TR]
[TD]Multi Head Weigher Rm[/TD]
[TD]MHW Retail 2[/TD]
[/TR]
[TR]
[TD]Multi Head Weigher Rm[/TD]
[TD]MHW Bulk[/TD]
[/TR]
[TR]
[TD]Multi Head Weigher Rm[/TD]
[TD]Hose Station South[/TD]
[/TR]
[TR]
[TD]Multi Head Weigher Rm[/TD]
[TD]Hose Station North[/TD]
[/TR]
[TR]
[TD]Packing Hall[/TD]
[TD]Roteg[/TD]
[/TR]
[TR]
[TD]Packing Hall[/TD]
[TD]Stretch Wrapper[/TD]
[/TR]
[TR]
[TD]Packing Hall[/TD]
[TD]Labeler[/TD]
[/TR]
[TR]
[TD]Packing Hall[/TD]
[TD]Hose Station[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]Bagger[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]Check Weigher[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]Metal Detector[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]Case Erector[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]Case Packer[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]Case Sealer[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]Labeler[/TD]
[/TR]
[TR]
[TD]Retail Line A[/TD]
[TD]All Conveyors[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]Bagger[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]Check Weigher[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]Metal Detector[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]Case Erector[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]Case Packer[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]Case Sealer[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]Labeler[/TD]
[/TR]
[TR]
[TD]Retail Line B[/TD]
[TD]All Conveyors[/TD]
[/TR]
[TR]
[TD]Bulk Line[/TD]
[TD]Bagger[/TD]
[/TR]
[TR]
[TD]Bulk Line[/TD]
[TD]Check Weigher[/TD]
[/TR]
[TR]
[TD]Bulk Line[/TD]
[TD]Metal Detector[/TD]
[/TR]
[TR]
[TD]Bulk Line[/TD]
[TD]All Conveyors[/TD]
[/TR]
[TR]
[TD]Bulk Line[/TD]
[TD]Lazy Susan[/TD]
[/TR]
[TR]
[TD]Chill Store[/TD]
[TD]Chill Store[/TD]
[/TR]
[TR]
[TD]Freezer Store[/TD]
[TD]Racking[/TD]
[/TR]
[TR]
[TD]Loading Bay[/TD]
[TD]Loading Bay 1[/TD]
[/TR]
[TR]
[TD]Loading Bay[/TD]
[TD]Loading Bay 2[/TD]
[/TR]
[TR]
[TD]Dry Store[/TD]
[TD]Racking[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Ammonia LP Comp[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Ammonia LP Pump[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Ammonia HP Comp[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Ammonia HP Pump[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Ammonia Swing Comp[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]HVAC Plant Room[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Workshop[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]1st Floor HVAC[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Marshalling Plant Room[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Paste Bin Store[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]2nd Floor CIP[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]2nd Floor Hot Water[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]2nd Floor HVAC[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Vac Mezanine Floor[/TD]
[/TR]
[TR]
[TD]Non Production Area's[/TD]
[TD]Main Switch Room[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Main Entrance[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Male Toilets[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Office[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Control Room[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Hygiene Change[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Ladies Change[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Dis/Ladies Toilet[/TD]
[/TR]
[TR]
[TD]Office & Ammenities[/TD]
[TD]Mess Room[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]Docking Area[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]Waste / Delivery Area[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]Effluent Pit[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]North Wall[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]North East Corner[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]East Wall[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]South East Corner[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]South Wall[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]Main Entrance[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]South West Wall[/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]West Wall [/TD]
[/TR]
[TR]
[TD]External Building Areas[/TD]
[TD]North West Wall[/TD]
[/TR]
[TR]
[TD]Other[/TD]
[TD]Other[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jameswizzpc]

Could you please simplify. I think I could help with this.

 

[danwaddy]

To clarify the second list in E.g. B2 should then show the list that relates to the Equipment / Tag / ID from within the selected location in A2.