conditional value

[censura]

hi i hope you can help, i have a spreadsheet which helps to organise our visits
it works by grouping client sites acoording to proximity to a rail station (central london and surrounding area)
i have two columns in the table 1 for selecting the nearest station from a defined drop down list, the 2nd column to assign a group code ie marylebone,baker st,paddigton,marble arch all have code bc, the idea is by selecting bc all sites local to these stations are displayed with other info making our visits more efficient. what i want is that by selecting the station the group code in the next column is automaticallly populated . i was going to use an if statement but it would be very long with 300 stations and the 15 group codes.
thank you

[VBA Noob]

Would a dependant list help

http://www.contextures.com/xlDataVal02.html

VBA Noob

[censura]

thank you, but not realy as i want the group value to be entered automatically ie if the bc group is made up of paddington,baker st, marble arch,bond st,queens way,lancaster gate ,notting hill gate an marylebone. if someone selects say paddington as the nearest station to a pecific client site then in the group column bc is automatically entered

thank you

[VBA Noob]

Set up a table and do a vlookup

http://www.contextures.com/xlFunctions02.html

VBA Noob

[censura]

thank you works well