A bit more Excel help (list boxes) - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » A bit more Excel help (list boxes)

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Aaron

Member

Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline

20th Mar 09 at 11:50

Right,

I've made a drop down list box so that the user of my spreadsheet can pick from a month of the calendar year. Great. But when they choose from the list (the list reads from another part of the spreadsheet which the user doesnt see), it returns the a number rather then the name of the month.

Like so....

it reads the info from here...

Without running some crazy long If statement....does anyone know how i can make it automatically display the name of the month rather then the number?

[Edited on 20-03-2009 by Aaron]

Aaron

Member

Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline

20th Mar 09 at 13:00

Anybody?

Chris Bingham

Member

Registered: 30th Mar 02
Location: In Scotland
User status: Offline

20th Mar 09 at 17:45

in cell BT, number the months 1 to 12. Then do a vlookup of the number that the drop down menu returns against your list and return the 2nd result and that'll bring back your month. Fairly common in the work I do that one.

Aaron

Member

Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline

20th Mar 09 at 18:06

*goes over my head*

Dont suppose i could email it over could i?