what is the best worksheet function to...
 

I have populated many cells in column A with the numbers 1 through 12. The
numbers are synonymous with the months of the year. However, I would like to
enter a formula in a cell in column B that looks at a cell in Column A,
determines which number is the cell and then populate the actual month in a
cell in column B. So if the number 12 was in cell A250, I would like the
formula B250 to look at cell A250, identify that it is populated with the
number 12 and then populate cell B250 with the word December. I would like to
run the formula on the entire list in Column A. So theoretically, each month
will appear in Column B because of the list of numbers 1 through 12 in column
A. How do I do this?

what is the best worksheet function to...
 

I am sure there are easier ways, but here are 2 ways that work:

=IF(AND(A2=1,A2<=12,A2=INT(A2)),TEXT(A2&", 2008","mmmm"))

or if you are really a glutton for punishment.
(you could add the same error handling as in the IF statement above).
=CHOOSE(A2,"January","February","March","April","M ay",June","July","August","September","October","N ovember","December")
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"dkholmes50" wrote:

I have populated many cells in column A with the numbers 1 through 12. The
numbers are synonymous with the months of the year. However, I would like to
enter a formula in a cell in column B that looks at a cell in Column A,
determines which number is the cell and then populate the actual month in a
cell in column B. So if the number 12 was in cell A250, I would like the
formula B250 to look at cell A250, identify that it is populated with the
number 12 and then populate cell B250 with the word December. I would like to
run the formula on the entire list in Column A. So theoretically, each month
will appear in Column B because of the list of numbers 1 through 12 in column
A. How do I do this?

what is the best worksheet function to...
 

Hi,

Try this

=DATE(2008,A250,1)

Format as mmmm

Mike

"dkholmes50" wrote:

I have populated many cells in column A with the numbers 1 through 12. The
numbers are synonymous with the months of the year. However, I would like to
enter a formula in a cell in column B that looks at a cell in Column A,
determines which number is the cell and then populate the actual month in a
cell in column B. So if the number 12 was in cell A250, I would like the
formula B250 to look at cell A250, identify that it is populated with the
number 12 and then populate cell B250 with the word December. I would like to
run the formula on the entire list in Column A. So theoretically, each month
will appear in Column B because of the list of numbers 1 through 12 in column
A. How do I do this?

what is the best worksheet function to...
 

List the months of the year for example in M1:M12 like this:

January
February
March
etc

Then in B250 you can use this formula:

=INDEX(M$1:M$12,A250)

If you want error handling you could use:

=IF(OR(A250<1,A25012),"",INDEX(M$1:M$12,A250))

Then just copy that down as required.

Hope this helps.

Pete


On Nov 13, 3:38*pm, dkholmes50
wrote:
I have populated many cells in column A with the numbers 1 through 12. The
numbers are synonymous with the months of the year. However, I would like to
enter a formula in a cell in column B that looks at a cell in Column A,
determines which number is the cell and then populate the actual month in a
cell in column B. So if the number 12 was in cell A250, I would like the
formula B250 to look at cell A250, identify that it is populated with the
number 12 and then populate cell B250 with the word December. I would like to
run the formula on the entire list in Column A. So theoretically, each month
will appear in Column B because of the list of numbers 1 through 12 in column
A. How do I do this?