Aaron
Member
Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline
|
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
|
Anybody?
|
Chris Bingham
Member
Registered: 30th Mar 02
Location: In Scotland
User status: Offline
|
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
|
*goes over my head*
Dont suppose i could email it over could i? 
|