How can I get data from a enumerated list?
For example, if I enter 3 in cell A1
, I would like cell B1
to display "march".
A1 3
B1 =FX(A1,"january,february,march,april,may")
Any function available for this? The list can be anything.
How can I get data from a enumerated list? For example, if I enter 3 in cell
Any function available for this? The list can be anything. 


The other answers provided so far suggest you reorganise your data to a format better suited to Excel's inbuilt functions and there are good reasons for doing so, but if you really must have your data in a commaseparated text string then the following will work:
You can substitute the "_" for any other character that won't appear in your list. 


Here are a few methods you can try: METHOD #1: TEXT() FUNCTIONThis will only work if you're working with months. In cell B1, enter:
You may replace 2000 with any year number. If you want to use the current year, replace 2000 with METHOD #2: CHOOSE() FUNCTIONIn cell B1, enter:
Typing this formula can be tiresome. To manage this a bit more quickly, you may try the ff. steps:
METHOD #3: INDEX() and a Named Range
**For example, if you choose to enter the months in cells D1 to D12. In the Refers to field, enter 


This is simply a key,value definition with a key lookup (and getting back the value). Use another sheet for that enumerated list, and use VLOOKUP on the first sheet. In this case the key is
and then on Sheet1:



You can use the vlookup function.
etc. Now enter the formula =VLOOKUP(A1,Sheet2!$A$1:$B$12,2,FALSE) 

