Hi, The above has helped me but the dropdowns I am using are on a form that people will sign. Using the above formulas means that the dropdown people select would have to be written in the array format. So say for example I had postage charges based on where people live. People selected their county, state or whatever in the dropdown the charges would appear. I don't want people to have to see IsleofMan as an option. I would like them to be able to select 'Isle of Man' i.e. with spaces between words.

Is there anyway that I can use the above formula but make B4 look pretty when selecting the dropdown? In the example spreadsheet above the option would be week1 on the dropdown whereas I would like people to be able to select Week 1 (with a space).

Any help you could give me would be greatly appreciated.

Thanks

Dec