Data Validation List with 12 sub lists

[russkris]

Hi,

I am trying to set up a data validation over 2 columns(B+C)

I have the B setup fine but the C column wont allow the amount of 'sub' lists.

=IF(B2="No Plan",GANoPlan,IF(B2="Far North West",GAFarNW,IF(B2="Port Sorell",GAPortS,IF(B2="Georges Bay",GAGeorge,IF(B2="Great Oyster Bay and Mercury Passage",GAGreatOys,IF(B2="Blackman Bay",GABlack,IF(B2="Tasman Peninsula and Norfolk Bay",GATasPen,IF(B2="Pittwater",GAPitt,IF(B2="Pipe Clay Lagoon",GAPipe,IF(B2="D'Entrecasteaux Channel",GADentre,IF(B2="Huon River and Port Esperance",GAHuon,IF(B2="Wild Area's",GAWild))))))))))))

Is there any way to make this easier?

 

[russkris]

Thank you very much for the help and the knowledge I have gained.... Everything works great.

 

[FDibbins]

Awesome, Im happy we got you where you wanted to be