hi i am creating an excel table which contains a data validation drop down
list. I would like to know if there is any way of linking an option selected
from the drop down list to another cell. E.g. my list contains 'Kingston,
Sutton, Wimbledon..' and i would like '£12.00' to appear in another cell when
Kingston is selected, '£8.00' when Sutton is selected and '£3.00' when
Wimbledon is selected. Is this possible? if so how?!