Hi Guys
I hope i can explain this properly. What i am trying to achieve is this. I have created a drop down list with specific entries. What i would like to achieve is that if someone picks a particular entry from the drop down list, another cell will populate with a pre defined entry ie
If i have a drop down list in A1 with the following:
London
Brighton
Liverpool
Manchester
i wold like B1 to populate with a predefined number depending on what selection is made at A1
So if i choose London B1 will show 50
Brighton B1 will show 30
Liverpool B1 will show 75
Mancers B1 will show 88
I hope this all makes sense.
Bookmarks