One way is to use a vlookup

Assume the reference listing (Location - Price)
is in Sheet2's cols A and B
eg: Kingston, 12

In Sheet1,
Assume DVs in A2 down
In B2: =IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))
Format B2 as currency to taste, copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Jemma" wrote:
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?!