Hello,

I'm sure the answer for this is somewhere on a forum, but I can't seem to find it. I'm sure it's easy if you know how.

There are a couple of things I need this to work for, but the basic idea is this...

I have set up a spreadsheet for a number of shows in different venues. In my C column is the name of the venue, selectable by a drop-down box.

In my D column I have the venue capacity. I would like this to be automatically filled when I select the venue in column C. e.g. If I have two venues, 'Jo's Bar' (capacity 200) and 'The Hippodrome' (capacity 1000), when I select Jo's Bar in column C, column D automatically displays '200'.

Thanks for any help!